APPS.HRI_OPL_SUP_STATUS_HST dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 274: per_assignment_status_types ast,

270: FROM per_all_assignments_f
271: WHERE assignment_type in ('E','C')
272: AND primary_flag = 'Y'
273: ) asg,
274: per_assignment_status_types ast,
275: (select person_id,
276: date_start,
277: actual_termination_date
278: from per_periods_of_service

Line 499: per_assignment_status_types ast,

495: FROM per_all_assignments_f
496: WHERE assignment_type in ('E','C')
497: AND primary_flag = 'Y'
498: ) asg,
499: per_assignment_status_types ast,
500: --
501: -- CWK Change
502: --
503: (select pos.person_id,

Line 749: per_assignment_status_types ast,

745: assignment_status_type_id
746: FROM per_all_assignments_f
747: WHERE assignment_type in ('E','C')
748: ) asg,
749: per_assignment_status_types ast,
750: (select person_id,
751: date_start,
752: actual_termination_date
753: from per_periods_of_service

Line 945: per_assignment_status_types ast,

941: assignment_status_type_id
942: FROM per_all_assignments_f
943: WHERE assignment_type in ('E','C')
944: ) asg,
945: per_assignment_status_types ast,
946: --
947: -- CWK Change
948: --
949: (select pos.person_id,