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_PAYMENT_XML_PKG dependencies on PAY_PAYROLLS_F

Line 485: , pay_payrolls_f prl

481: , per_all_people_f ppf
482: , per_periods_of_service pps
483: , per_jobs pj
484: , hr_organization_units hou
485: , pay_payrolls_f prl
486: WHERE paf.person_id = ppf.person_id
487: and paf.assignment_id = p_assignment_id
488: AND paf.job_id = pj.job_id(+)
489: and paf.organization_id = hou.organization_id

Line 513: , pay_payrolls_f pp

509: CURSOR get_payroll_details(p_prepru_pact_id in number)
510: IS
511: SELECT ppa.start_date
512: FROM pay_payroll_actions ppa
513: , pay_payrolls_f pp
514: WHERE ppa.payroll_action_id = p_prepru_pact_id
515: and pp.payroll_id = ppa.payroll_id
516: and ppa.effective_date between pp.effective_start_date
517: and pp.effective_end_date;

Line 634: l_payroll_name pay_payrolls_f.payroll_name%TYPE;

630: l_payroll_start_date date;
631: l_payroll_end_date date;
632: l_cheque_no varchar2(30);
633: l_effective_date date;
634: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
635: l_job per_jobs.name%TYPE;
636: l_employer hr_organization_units.name%TYPE;
637: l_payroll_id number;
638: l_chq_effective_date varchar2(30);