APPS.PAY_ZA_COIDA_ARCHIVE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 793: from per_assignment_status_types past,

789: hr_utility.set_location('L_START_PY_ADV_DT :'||L_START_PY_ADV_DT,15);
790:
791: select max(past.per_system_status)
792: into l_per_system_status
793: from per_assignment_status_types past,
794: per_all_assignments_f asg
795: where past.assignment_status_type_id = asg.assignment_status_type_id
796: and asg.assignment_id = p_asg_id
797: and past.per_system_status = 'ACTIVE_ASSIGN'

Line 807: from per_assignment_status_types past,

803: if l_per_system_status is null then
804:
805: select past.per_system_status
806: into l_per_system_status
807: from per_assignment_status_types past,
808: per_all_assignments_f asg
809: where past.assignment_status_type_id = asg.assignment_status_type_id
810: and asg.assignment_id = p_asg_id
811: and p_date between asg.effective_start_date and asg.effective_end_date;