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 835: pay_all_payrolls_f pay,

831: paa.assignment_action_id),16)) assignment_action_id
832: from per_all_assignments_f a,
833: pay_assignment_actions paa,
834: pay_payroll_actions ppa,
835: pay_all_payrolls_f pay,
836: hr_soft_coding_keyflex flex
837: ,(SELECT a2.assignment_id, max(a2.effective_start_date) max_effective_start_date -- Bug 9292092
838: FROM per_all_assignments_f a2,
839: per_assignment_status_types past

Line 1287: pay_all_payrolls_f ppf,

1283: CURSOR csr_tax_ref (c_assignment_id in number,
1284: c_effective_end_date in date) is
1285: select scl.segment1
1286: from per_all_assignments_f paf,
1287: pay_all_payrolls_f ppf,
1288: hr_soft_coding_keyflex scl
1289: where paf.assignment_id = c_assignment_id
1290: and paf.payroll_id = ppf.payroll_id
1291: and scl.soft_coding_keyflex_id = ppf.soft_coding_keyflex_id

Line 1353: pay_all_payrolls_f ppf,

1349: CURSOR csr_tax_ref (c_assignment_id in number,
1350: c_effective_end_date in date) is
1351: select scl.segment1
1352: from per_all_assignments_f paf,
1353: pay_all_payrolls_f ppf,
1354: hr_soft_coding_keyflex scl
1355: where paf.assignment_id = c_assignment_id
1356: and paf.payroll_id = ppf.payroll_id
1357: and scl.soft_coding_keyflex_id = ppf.soft_coding_keyflex_id

Line 1949: pay_all_payrolls_f ppf,

1945: c_tax_ref in varchar2) is
1946: select 1 from dual where exists
1947: (select scl.segment1
1948: from per_all_assignments_f paf,
1949: pay_all_payrolls_f ppf,
1950: hr_soft_coding_keyflex scl
1951: where paf.assignment_id = c_assignment_id
1952: and paf.payroll_id = ppf.payroll_id
1953: and scl.soft_coding_keyflex_id = ppf.soft_coding_keyflex_id

Line 2239: pay_all_payrolls_f pay,

2235: c_agg_end_date in date) is
2236: select a.assignment_id,
2237: a.effective_end_date
2238: from per_all_assignments_f a,
2239: pay_all_payrolls_f pay,
2240: hr_soft_coding_keyflex flex,
2241: per_periods_of_service serv
2242: where a.person_id = c_person_id
2243: and flex.segment1 = c_tax_ref

Line 2289: pay_all_payrolls_f ppf,

2285: ptp.regular_payment_date
2286: FROM per_all_people_f p,
2287: per_all_assignments_f a,
2288: per_assignment_status_types past,
2289: pay_all_payrolls_f ppf,
2290: per_time_periods ptp,
2291: per_periods_of_service serv,
2292: hr_soft_coding_keyflex flex
2293: WHERE a.person_id BETWEEN stperson AND endperson

Line 2348: pay_all_payrolls_f ppf,

2344: FROM pay_population_ranges ppr,
2345: per_all_people_f p,
2346: per_all_assignments_f a,
2347: per_assignment_status_types past,
2348: pay_all_payrolls_f ppf,
2349: per_time_periods ptp,
2350: per_periods_of_service serv,
2351: hr_soft_coding_keyflex flex
2352: WHERE p.person_id = ppr.person_id

Line 4843: pay_all_payrolls_f papf,

4839:
4840: Cursor csr_get_paye_ref(c_assignment_id NUMBER, c_effective_date DATE) IS
4841: SELECT flex.segment1 paye_ref, paaf.period_of_service_id
4842: FROM per_all_assignments_f paaf,
4843: pay_all_payrolls_f papf,
4844: hr_soft_coding_keyflex flex
4845: WHERE paaf.assignment_id = c_assignment_id
4846: AND c_effective_date between paaf.effective_start_date and paaf.effective_end_date
4847: AND paaf.payroll_id = papf.payroll_id