APPS.PAY_GB_RTI_FPS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1567: per_assignment_status_types past,

1563: CURSOR csr_get_term_asg_info (p_asg_id NUMBER)
1564: IS
1565: SELECT min(paaf.effective_start_date) min_active_start_date
1566: FROM per_all_assignments_f paaf,
1567: per_assignment_status_types past,
1568: pay_all_payrolls_f pay,
1569: hr_soft_coding_keyflex sck
1570: WHERE paaf.assignment_id = p_asg_id
1571: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 2375: per_assignment_status_types past,

2371: CURSOR csr_get_term_asg_info (p_asg_id NUMBER)
2372: IS
2373: SELECT min(paaf.effective_start_date) min_active_start_date
2374: FROM per_all_assignments_f paaf,
2375: per_assignment_status_types past,
2376: pay_all_payrolls_f pay,
2377: hr_soft_coding_keyflex sck
2378: WHERE paaf.assignment_id = p_asg_id
2379: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 3189: per_assignment_status_types past,

3185: CURSOR csr_get_term_asg_info (p_asg_id NUMBER)
3186: IS
3187: SELECT min(paaf.effective_start_date) min_active_start_date
3188: FROM per_all_assignments_f paaf,
3189: per_assignment_status_types past,
3190: pay_all_payrolls_f pay,
3191: hr_soft_coding_keyflex sck
3192: WHERE paaf.assignment_id = p_asg_id
3193: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 3786: per_assignment_status_types past

3782: select paaf.effective_start_date from
3783: per_all_assignments_f paaf,
3784: pay_all_payrolls_f papf ,
3785: hr_soft_coding_keyflex flex,
3786: per_assignment_status_types past
3787: where paaf.assignment_id = asg_id and paaf.effective_end_date = eff_date - 1
3788: and papf.payroll_id = paaf.payroll_id
3789: and flex.SOFT_CODING_KEYFLEX_ID = papf.SOFT_CODING_KEYFLEX_ID
3790: and upper(l_tax_ref) = upper(flex.segment1)

Line 6249: per_assignment_status_types past --,

6245: trim(pap.per_information10) per_agg_flag,
6246: pap.person_id
6247: from per_all_people_f pap,
6248: per_all_assignments_f paaf,
6249: per_assignment_status_types past --,
6250: --pay_payroll_actions paa
6251: where pap.person_id between stperson and endperson
6252: -- and paa.payroll_Action_id = p_prepay_id
6253: and pap.person_id = paaf.person_id

Line 12666: per_assignment_status_types past,

12662: TO_CHAR(paa.EFFECTIVE_START_DATE,'DD-MON-RRRR') start_date,
12663: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
12664: pap.person_id
12665: FROM per_all_assignments_f paa,
12666: per_assignment_status_types past,
12667: per_all_people_f pap
12668: WHERE paa.person_id = pap.person_id
12669: AND paa.assignment_id = c_assignment_id
12670: AND past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID