APPS.PAY_GB_RTI_EYU dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 610: per_assignment_status_types past

606: CURSOR csr_get_term_asg_info (p_asg_id NUMBER)
607: IS
608: SELECT min(paaf.effective_start_date) min_active_start_date
609: FROM per_all_assignments_f paaf,
610: per_assignment_status_types past
611: WHERE paaf.assignment_id = p_asg_id
612: AND paaf.assignment_status_type_id = past.assignment_status_type_id
613: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
614:

Line 3853: per_assignment_status_types past,

3849: select distinct asg.assignment_id assignment_id,trim(pap.per_information10) per_agg_flag,trim(pap.per_information9) per_ni_flag,
3850: pap.person_id person_id , asg.assignment_number l_asg_num
3851: from per_all_people_f pap,
3852: per_all_assignments_f asg,
3853: per_assignment_status_types past,
3854: pay_all_payrolls_f pay,
3855: hr_soft_coding_keyflex sck
3856: where pap.person_id between stperson and endperson
3857: and pap.person_id = asg.person_id

Line 6006: per_assignment_status_types past,

6002: TO_CHAR(paa.EFFECTIVE_START_DATE,'DD-MON-RRRR') start_date,
6003: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
6004: pap.person_id
6005: FROM per_all_assignments_f paa,
6006: per_assignment_status_types past,
6007: per_all_people_f pap
6008: WHERE paa.person_id = pap.person_id
6009: AND paa.assignment_id = c_assignment_id
6010: AND past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID