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.PYCADAR_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 252: pay_all_payrolls_f ppf

248: per_all_assignments_f asg,
249: per_periods_of_service pos,
250: pay_payroll_actions pa2,
251: pay_payroll_actions pa1,
252: pay_all_payrolls_f ppf
253: where pa1.payroll_action_id = :payroll_action_id
254: and ppf.payroll_id = pycadar_pkg.get_parameter(''PAYROLL_ID'',
255: pa1.legislative_parameters)
256: and pa2.consolidation_set_id =

Line 280: pay_all_payrolls_f ppf

276: per_all_assignments_f asg,
277: per_periods_of_service pos,
278: pay_payroll_actions pa2,
279: pay_payroll_actions pa1,
280: pay_all_payrolls_f ppf
281: where pa1.payroll_action_id = :payroll_action_id
282: and pa2.consolidation_set_id =
283: pycadar_pkg.get_parameter(''CONSOLIDATION_SET_ID'',
284: pa1.legislative_parameters)

Line 413: -- added pay_all_payrolls_f table in the main query to use correct indexes

409: c_actions PaidActions;
410: --
411: --
412: -- Bug#3331023 removed rule hint for c_actions_zero_pay cursor and
413: -- added pay_all_payrolls_f table in the main query to use correct indexes
414:
415: CURSOR c_actions_zero_pay
416: (
417: pactid number,

Line 429: pay_all_payrolls_f ppf

425: per_all_assignments_f paf1,
426: per_periods_of_service pos,
427: pay_payroll_actions ppa_dar,
428: pay_payroll_actions ppa_mag_pmts,
429: pay_all_payrolls_f ppf
430: where ( ppa_dar.payroll_action_id = pactid
431: and ppa_mag_pmts.consolidation_set_id =
432: pycadar_pkg.get_parameter('CONSOLIDATION_SET_ID',
433: ppa_dar.legislative_parameters)

Line 503: pay_all_payrolls_f ppf,

499: per_all_assignments_f paf2,
500: per_periods_of_service pos,
501: pay_payroll_actions ppa_dar,
502: pay_payroll_actions ppa_mag,
503: pay_all_payrolls_f ppf,
504: hr_assignment_sets has,
505: hr_assignment_set_amendments hasa
506: where ppa_dar.payroll_action_id = pactid
507: and has.assignment_set_id = p_assignment_set_id

Line 654: pay_all_payrolls_f ppf

650: per_all_assignments_f paf2,
651: per_periods_of_service pos,
652: pay_payroll_actions ppa_dar,
653: pay_payroll_actions ppa_mag,
654: pay_all_payrolls_f ppf
655: where ppa_dar.payroll_action_id = :pactid
656: and nvl(ppa_mag.payroll_id,ppf.payroll_id) =
657: NVL(pycadar_pkg.get_parameter(''PAYROLL_ID'',
658: ppa_dar.legislative_parameters),