APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2077: per_assignment_status_types past

2073: CURSOR csr_get_term_asg_info (p_asg_id NUMBER)
2074: IS
2075: SELECT min(paaf.effective_start_date) min_active_start_date
2076: FROM per_all_assignments_f paaf,
2077: per_assignment_status_types past
2078: WHERE paaf.assignment_id = p_asg_id
2079: AND paaf.assignment_status_type_id = past.assignment_status_type_id
2080: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
2081:

Line 2853: per_assignment_status_types past

2849: CURSOR csr_get_term_asg_info (p_asg_id NUMBER)
2850: IS
2851: SELECT min(paaf.effective_start_date) min_active_start_date
2852: FROM per_all_assignments_f paaf,
2853: per_assignment_status_types past
2854: WHERE paaf.assignment_id = p_asg_id
2855: AND paaf.assignment_status_type_id = past.assignment_status_type_id
2856: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
2857:

Line 3656: per_assignment_status_types past

3652: CURSOR csr_get_term_asg_info (p_asg_id NUMBER)
3653: IS
3654: SELECT min(paaf.effective_start_date) min_active_start_date
3655: FROM per_all_assignments_f paaf,
3656: per_assignment_status_types past
3657: WHERE paaf.assignment_id = p_asg_id
3658: AND paaf.assignment_status_type_id = past.assignment_status_type_id
3659: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
3660:

Line 4358: per_assignment_status_types past

4354: select paaf.effective_start_date from
4355: per_all_assignments_f paaf,
4356: pay_all_payrolls_f papf ,
4357: hr_soft_coding_keyflex flex,
4358: per_assignment_status_types past
4359: where paaf.assignment_id = asg_id and paaf.effective_end_date = eff_date - 1
4360: and papf.payroll_id = paaf.payroll_id
4361: and flex.SOFT_CODING_KEYFLEX_ID = papf.SOFT_CODING_KEYFLEX_ID
4362: and upper(l_tax_ref) = upper(flex.segment1)

Line 6918: per_assignment_status_types past,

6914: trim(pap.per_information10) per_agg_flag,
6915: pap.person_id
6916: from per_all_people_f pap,
6917: per_all_assignments_f paaf,
6918: per_assignment_status_types past,
6919: pay_payroll_actions paa
6920: where pap.person_id between stperson and endperson
6921: and paa.payroll_Action_id = p_prepay_id
6922: and pap.person_id = paaf.person_id

Line 13421: per_assignment_status_types past,

13417: TO_CHAR(paa.EFFECTIVE_START_DATE,'DD-MON-RRRR') start_date,
13418: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
13419: pap.person_id
13420: FROM per_all_assignments_f paa,
13421: per_assignment_status_types past,
13422: per_all_people_f pap
13423: WHERE paa.person_id = pap.person_id
13424: AND paa.assignment_id = c_assignment_id
13425: AND past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID