APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 615: , per_assignment_status_types sta

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

Line 629: , per_assignment_status_types sta

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

Line 946: , per_assignment_status_types sta

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

Line 1150: , per_assignment_status_types sta

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