APPS.PAY_GB_RTI_EAS dependencies on PAY_ALL_PAYROLLS_F

Line 916: pay_all_payrolls_f papf ,

912: per_all_assignments_f paaf,
913: per_all_assignments_f paaf1,
914: per_assignment_status_types past,
915: per_assignment_status_types past1,
916: pay_all_payrolls_f papf ,
917: pay_all_payrolls_f papf1,
918: hr_soft_coding_keyflex flex
919: where
920: peo.person_id = p_person_id

Line 917: pay_all_payrolls_f papf1,

913: per_all_assignments_f paaf1,
914: per_assignment_status_types past,
915: per_assignment_status_types past1,
916: pay_all_payrolls_f papf ,
917: pay_all_payrolls_f papf1,
918: hr_soft_coding_keyflex flex
919: where
920: peo.person_id = p_person_id
921: and paaf.person_id = peo.person_id

Line 953: pay_all_payrolls_f papf ,

949: cursor csr_get_start_end_dates(p_eff_date date,p_tax_ref varchar2) is
950: select paaf.effective_start_date,paaf.effective_end_date
951: from
952: per_all_assignments_f paaf,
953: pay_all_payrolls_f papf ,
954: hr_soft_coding_keyflex flex,
955: per_assignment_status_types past
956: where
957: paaf.assignment_id = p_person_rec.assignment_id

Line 2393: pay_all_payrolls_f pay,

2389: from per_all_people_f pap,
2390: per_all_assignments_f asg,
2391: per_assignment_status_types past,
2392: per_periods_of_service serv,
2393: pay_all_payrolls_f pay,
2394: hr_soft_coding_keyflex sck,
2395: hr_organization_information org
2396: where pap.person_id between stperson and endperson
2397: and pap.current_employee_flag = 'Y'

Line 2432: pay_all_payrolls_f pay,

2428: pap.person_id person_id, serv.actual_termination_date actual_termination_date
2429: from per_all_people_f pap,
2430: per_all_assignments_f asg,
2431: per_periods_of_service serv,
2432: pay_all_payrolls_f pay,
2433: hr_soft_coding_keyflex sck,
2434: hr_organization_information org
2435: where pap.person_id between stperson and endperson
2436: and serv.actual_termination_date is not null

Line 2483: pay_all_payrolls_f papf ,

2479: per_all_assignments_f paaf,
2480: per_all_assignments_f paaf1,
2481: per_assignment_status_types past,
2482: per_assignment_status_types past1,
2483: pay_all_payrolls_f papf ,
2484: hr_soft_coding_keyflex flex
2485: where
2486: peo.person_id = p_person_id
2487: and paaf.person_id = peo.person_id

Line 2716: pay_all_payrolls_f pay,

2712: pap.person_id person_id,asg.effective_start_date effective_start_date
2713: from per_all_people_f pap,
2714: per_all_assignments_f asg,
2715: per_periods_of_service serv,
2716: pay_all_payrolls_f pay,
2717: hr_soft_coding_keyflex sck,
2718: per_people_extra_info ppei
2719: where pap.person_id between stperson and endperson
2720: and pap.person_id =ppei.person_id (+)

Line 4218: pay_all_payrolls_f papf ,

4214: l_eff_date date;
4215: cursor csr_get_start_date is
4216: select paaf.effective_start_date from
4217: per_all_assignments_f paaf,
4218: pay_all_payrolls_f papf ,
4219: hr_soft_coding_keyflex flex,
4220: per_assignment_status_types past
4221: where paaf.assignment_id = asg_id and paaf.effective_end_date = eff_date - 1
4222: and papf.payroll_id = paaf.payroll_id

Line 4247: pay_all_payrolls_f papf ,

4243: cursor csr_get_end_date is
4244: select paaf.effective_end_date
4245: from
4246: per_all_assignments_f paaf,
4247: pay_all_payrolls_f papf ,
4248: hr_soft_coding_keyflex flex,
4249: per_assignment_status_types past
4250: where paaf.assignment_id = asg_id and paaf.effective_start_date = eff_date + 1
4251: and papf.payroll_id = paaf.payroll_id