eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_P45_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 770: pay_all_payrolls_f pay,

766: paa.assignment_action_id),16)) assignment_action_id
767: from per_all_assignments_f a,
768: pay_assignment_actions paa,
769: pay_payroll_actions ppa,
770: pay_all_payrolls_f pay,
771: hr_soft_coding_keyflex flex
772: where a.person_id = c_person_id
773: and paa.assignment_id = a.assignment_id
774: and ppa.payroll_action_id = paa.payroll_action_id

Line 1180: pay_all_payrolls_f ppf,

1176: CURSOR csr_tax_ref (c_assignment_id in number,
1177: c_effective_end_date in date) is
1178: select scl.segment1
1179: from per_all_assignments_f paf,
1180: pay_all_payrolls_f ppf,
1181: hr_soft_coding_keyflex scl
1182: where paf.assignment_id = c_assignment_id
1183: and paf.payroll_id = ppf.payroll_id
1184: and scl.soft_coding_keyflex_id = ppf.soft_coding_keyflex_id

Line 1245: pay_all_payrolls_f ppf,

1241: CURSOR csr_tax_ref (c_assignment_id in number,
1242: c_effective_end_date in date) is
1243: select scl.segment1
1244: from per_all_assignments_f paf,
1245: pay_all_payrolls_f ppf,
1246: hr_soft_coding_keyflex scl
1247: where paf.assignment_id = c_assignment_id
1248: and paf.payroll_id = ppf.payroll_id
1249: and scl.soft_coding_keyflex_id = ppf.soft_coding_keyflex_id

Line 1830: pay_all_payrolls_f ppf,

1826: c_tax_ref in varchar2) is
1827: select 1 from dual where exists
1828: (select scl.segment1
1829: from per_all_assignments_f paf,
1830: pay_all_payrolls_f ppf,
1831: hr_soft_coding_keyflex scl
1832: where paf.assignment_id = c_assignment_id
1833: and paf.payroll_id = ppf.payroll_id
1834: and scl.soft_coding_keyflex_id = ppf.soft_coding_keyflex_id

Line 2112: pay_all_payrolls_f pay,

2108: c_agg_end_date in date) is
2109: select a.assignment_id,
2110: a.effective_end_date
2111: from per_all_assignments_f a,
2112: pay_all_payrolls_f pay,
2113: hr_soft_coding_keyflex flex,
2114: per_periods_of_service serv
2115: where a.person_id = c_person_id
2116: and flex.segment1 = c_tax_ref

Line 2162: pay_all_payrolls_f ppf,

2158: ptp.regular_payment_date
2159: FROM per_all_people_f p,
2160: per_all_assignments_f a,
2161: per_assignment_status_types past,
2162: pay_all_payrolls_f ppf,
2163: per_time_periods ptp,
2164: per_periods_of_service serv,
2165: hr_soft_coding_keyflex flex
2166: WHERE a.person_id BETWEEN stperson AND endperson

Line 2217: pay_all_payrolls_f ppf,

2213: FROM pay_population_ranges ppr,
2214: per_all_people_f p,
2215: per_all_assignments_f a,
2216: per_assignment_status_types past,
2217: pay_all_payrolls_f ppf,
2218: per_time_periods ptp,
2219: per_periods_of_service serv,
2220: hr_soft_coding_keyflex flex
2221: WHERE p.person_id = ppr.person_id

Line 4036: pay_all_payrolls_f papf,

4032:
4033: Cursor csr_get_paye_ref(c_assignment_id NUMBER, c_effective_date DATE) IS
4034: SELECT flex.segment1 paye_ref, paaf.period_of_service_id
4035: FROM per_all_assignments_f paaf,
4036: pay_all_payrolls_f papf,
4037: hr_soft_coding_keyflex flex
4038: WHERE paaf.assignment_id = c_assignment_id
4039: AND c_effective_date between paaf.effective_start_date and paaf.effective_end_date
4040: AND paaf.payroll_id = papf.payroll_id