APPS.PAY_GB_AEI_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 294: per_assignment_status_types past,

290: extra.aei_information4
291: from per_all_assignments_f a,
292: pay_all_payrolls_f pay,
293: hr_soft_coding_keyflex flex,
294: per_assignment_status_types past,
295: per_assignment_extra_info extra
296: where a.person_id = c_person_id
297: and flex.segment1 = c_tax_ref
298: and pay.soft_coding_keyflex_id = flex.soft_coding_keyflex_id

Line 318: per_assignment_status_types past

314: --
315: cursor csr_asg_last_active_date(c_assignment_id number) is
316: select max(effective_end_date)
317: from per_all_assignments_f a,
318: per_assignment_status_types past
319: where a.assignment_id = c_assignment_id
320: and a.assignment_status_type_id = past.assignment_status_type_id
321: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
322:

Line 765: per_assignment_status_types past,

761: extra.aei_information4
762: from per_all_assignments_f a,
763: pay_all_payrolls_f pay,
764: hr_soft_coding_keyflex flex,
765: per_assignment_status_types past,
766: per_assignment_extra_info extra
767: where a.person_id = c_person_id
768: and flex.segment1 = c_tax_ref
769: and pay.soft_coding_keyflex_id = flex.soft_coding_keyflex_id

Line 789: per_assignment_status_types past

785: --
786: cursor csr_asg_last_active_date(c_assignment_id number) is
787: select max(effective_end_date)
788: from per_all_assignments_f a,
789: per_assignment_status_types past
790: where a.assignment_id = c_assignment_id
791: and a.assignment_status_type_id = past.assignment_status_type_id
792: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
793:

Line 1468: per_assignment_status_types past,

1464: extra.aei_information4
1465: from per_all_assignments_f a,
1466: pay_all_payrolls_f pay,
1467: hr_soft_coding_keyflex flex,
1468: per_assignment_status_types past,
1469: per_assignment_extra_info extra
1470: where a.person_id = c_person_id
1471: and flex.segment1 = c_tax_ref
1472: and pay.soft_coding_keyflex_id = flex.soft_coding_keyflex_id

Line 1491: per_assignment_status_types past

1487: --
1488: cursor csr_asg_last_active_date(c_assignment_id number) is
1489: select max(effective_end_date)
1490: from per_all_assignments_f a,
1491: per_assignment_status_types past
1492: where a.assignment_id = c_assignment_id
1493: and a.assignment_status_type_id = past.assignment_status_type_id
1494: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
1495: