Operation Details
Description: Returns the employer name and employee name for an employment where the employer is registered as a representative.
Sterotype: ns
SQL
SELECT
  ConcernRole.concernRoleName,
  Representative.representativeName
INTO
  :employeeName,
  :employerName 
FROM
  ConcernRole,
  Representative,
  Employment 
WHERE Employment.employmentID = :employmentID 
  AND Representative.concernRoleID = Employment.employerConcernRoleID 
  AND ConcernRole.concernRoleID = Employment.concernRoleID