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_ACCRUAL_PLANS

Line 566: FROM pay_accrual_plans pap

562: CURSOR csr_leave_balance (p_assignment_id in number,p_eff_date in date)
563: is
564: SELECT pap.accrual_plan_name
565: , pap.accrual_plan_id
566: FROM pay_accrual_plans pap
567: ,pay_element_types_f pet
568: ,pay_element_links_f pel
569: ,pay_element_entries_f pee
570: WHERE pet.element_type_id = pap.accrual_plan_element_type_id

Line 685: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE;

681: l_annual_leave_balance NUMBER;
682: l_period_end_date DATE;
683: l_period_start_date DATE;
684: l_leave_taken NUMBER;
685: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
686: l_run_aa_id number;
687: l_pactid NUMBER;
688: decimal_amount varchar2(2000);
689: found boolean:=false;