DBA Data[Home] [Help]

APPS.PAY_GB_AEI_API dependencies on PAY_ALL_PAYROLLS_F

Line 261: pay_all_payrolls_f papf,

257: CURSOR tax_district(c_assignment_id in number,
258: c_effective_date in date) IS
259: SELECT hsck.segment1, period_of_service_id
260: FROM hr_soft_coding_keyflex hsck,
261: pay_all_payrolls_f papf,
262: per_all_assignments_f paaf
263: WHERE hsck.soft_coding_keyflex_id = papf.soft_coding_keyflex_id
264: AND papf.payroll_id = paaf.payroll_id
265: AND paaf.assignment_id = c_assignment_id

Line 292: pay_all_payrolls_f pay,

288: extra.aei_information2,
289: extra.aei_information3,
290: extra.aei_information4
291: from per_all_assignments_f a,
292: pay_all_payrolls_f pay,
293: hr_soft_coding_keyflex flex,
294: per_assignment_status_types past,
295: per_assignment_extra_info extra
296: where a.person_id = c_person_id

Line 729: pay_all_payrolls_f papf,

725: CURSOR tax_district(c_assignment_id in number,
726: c_effective_date in date) IS
727: SELECT hsck.segment1, period_of_service_id
728: FROM hr_soft_coding_keyflex hsck,
729: pay_all_payrolls_f papf,
730: per_all_assignments_f paaf
731: WHERE hsck.soft_coding_keyflex_id = papf.soft_coding_keyflex_id
732: AND papf.payroll_id = paaf.payroll_id
733: AND paaf.assignment_id = c_assignment_id

Line 763: pay_all_payrolls_f pay,

759: extra.aei_information2,
760: extra.aei_information3,
761: extra.aei_information4
762: from per_all_assignments_f a,
763: pay_all_payrolls_f pay,
764: hr_soft_coding_keyflex flex,
765: per_assignment_status_types past,
766: per_assignment_extra_info extra
767: where a.person_id = c_person_id

Line 1432: pay_all_payrolls_f papf,

1428: CURSOR tax_district(c_assignment_id in number,
1429: c_effective_date in date) IS
1430: SELECT hsck.segment1, period_of_service_id, person_id
1431: FROM hr_soft_coding_keyflex hsck,
1432: pay_all_payrolls_f papf,
1433: per_all_assignments_f paaf
1434: WHERE hsck.soft_coding_keyflex_id = papf.soft_coding_keyflex_id
1435: AND papf.payroll_id = paaf.payroll_id
1436: AND paaf.assignment_id = c_assignment_id

Line 1466: pay_all_payrolls_f pay,

1462: extra.aei_information2,
1463: extra.aei_information3,
1464: extra.aei_information4
1465: from per_all_assignments_f a,
1466: pay_all_payrolls_f pay,
1467: hr_soft_coding_keyflex flex,
1468: per_assignment_status_types past,
1469: per_assignment_extra_info extra
1470: where a.person_id = c_person_id