APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2418: FROM per_assignment_status_types

2414: AND pds_information_category='MX';
2415:
2416: CURSOR c_asg_status_type ( cp_asg_status_type_id IN NUMBER) IS
2417: SELECT per_system_status
2418: FROM per_assignment_status_types
2419: WHERE assignment_status_type_id = cp_asg_status_type_id;
2420:
2421: CURSOR csr_asg_exists (cp_effective_date DATE) IS
2422: SELECT 'X'

Line 2438: per_assignment_status_types pst

2434: CURSOR csr_per_gre (cp_effective_date DATE,
2435: cp_tran_type VARCHAR2) IS
2436: SELECT 'Y'
2437: FROM per_assignments_f paf,
2438: per_assignment_status_types pst
2439: WHERE paf.person_id = p_person_id
2440: --AND paf.assignment_id <> p_assignment_id
2441: AND paf.assignment_status_type_id = pst.assignment_status_type_id
2442: AND ((cp_effective_date < paf.effective_end_date AND