APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2542: FROM per_assignment_status_types

2538: AND pds_information_category='MX';
2539:
2540: CURSOR c_asg_status_type ( cp_asg_status_type_id IN NUMBER) IS
2541: SELECT per_system_status
2542: FROM per_assignment_status_types
2543: WHERE assignment_status_type_id = cp_asg_status_type_id;
2544:
2545: CURSOR csr_asg_exists (cp_effective_date DATE) IS
2546: SELECT 'X'

Line 2562: per_assignment_status_types pst

2558: CURSOR csr_per_gre (cp_effective_date DATE,
2559: cp_tran_type VARCHAR2) IS
2560: SELECT 'Y'
2561: FROM per_assignments_f paf,
2562: per_assignment_status_types pst
2563: WHERE paf.person_id = p_person_id
2564: --AND paf.assignment_id <> p_assignment_id
2565: AND paf.assignment_status_type_id = pst.assignment_status_type_id
2566: AND ((cp_effective_date < paf.effective_end_date AND