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_AU_TERMINATIONS dependencies on PAY_ACCRUAL_PLANS

Line 613: from pay_accrual_plans pap,

609: ,p_effective_date date
610: ,p_plan_category varchar2
611: ) is
612: select pap.accrual_plan_id
613: from pay_accrual_plans pap,
614: pay_element_entries_f pee,
615: pay_element_links_f pel,
616: pay_element_types_f pet
617: where pee.assignment_id = p_assignment_id

Line 1203: , pay_accrual_plans pap

1199: ) is
1200: select to_number(hrl.description)
1201: from pay_element_types_f petf
1202: , pay_input_values_f pivf
1203: , pay_accrual_plans pap
1204: , hr_lookups hrl
1205: , pay_element_classifications pec
1206: where pap.accrual_plan_id = p_accrual_plan_id
1207: and pivf.input_value_id = pap.pto_input_value_id

Line 1712: FROM pay_accrual_plans pap,

1708: CURSOR csr_get_accrual_plan_id(p_assignment_id NUMBER
1709: ,p_effective_date DATE
1710: ,p_plan_category VARCHAR2) IS
1711: SELECT pap.accrual_plan_id,pap.accrual_units_of_measure
1712: FROM pay_accrual_plans pap,
1713: pay_element_entries_f pee,
1714: pay_element_links_f pel,
1715: pay_element_types_f pet
1716: WHERE pee.assignment_id = p_assignment_id