APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 614: , per_assignment_status_types sta

610: and asg.effective_end_date =
611: (
612: select max(asg2.effective_end_date)
613: from per_assignments_f asg2
614: , per_assignment_status_types sta
615: where asg2.assignment_id = asg.assignment_id
616: and asg2.assignment_status_type_id = sta.assignment_status_type_id
617: and sta.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
618: )

Line 628: , per_assignment_status_types sta

624: and asg3.effective_start_date =
625: (
626: select min(asg4.effective_start_date)
627: from per_assignments_f asg4
628: , per_assignment_status_types sta
629: where asg4.assignment_id = asg3.assignment_id
630: and asg4.assignment_status_type_id = sta.assignment_status_type_id
631: and sta.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
632: )

Line 945: , per_assignment_status_types sta

941:
942: cursor csr_asg_start (p_asg_id number) is
943: select min(asg2.effective_start_date)
944: from per_assignments_f asg2
945: , per_assignment_status_types sta
946: where asg2.assignment_id = p_asg_id
947: and asg2.assignment_status_type_id = sta.assignment_status_type_id
948: and sta.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN', 'TERM_ASSIGN'); -- Added 'TERM_ASSIGN' for bug 3869426
949:

Line 1148: , per_assignment_status_types sta

1144: and asg.effective_end_date =
1145: (
1146: select max(asg2.effective_end_date)
1147: from per_assignments_f asg2
1148: , per_assignment_status_types sta
1149: where asg2.assignment_id = l_asgid --Bug 4768622
1150: and asg2.assignment_status_type_id = sta.assignment_status_type_id
1151: and sta.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN') -- Bug 4306265: Removed 'TERM_ASSIGN') -- Added 'TERM_ASSIGN' for bug 3869426
1152: );