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.HR_AU_HOLIDAYS dependencies on PAY_ELEMENT_LINKS_F

Line 1199: pay_element_links_f pel,

1195: ,p_plan_category VARCHAR2) IS
1196: SELECT pap.accrual_plan_id
1197: FROM pay_accrual_plans pap,
1198: pay_element_entries_f pee,
1199: pay_element_links_f pel,
1200: pay_element_types_f pet
1201: WHERE pee.assignment_id = p_assignment_id
1202: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
1203: AND p_effective_date BETWEEN pel.effective_start_date AND pel.effective_end_date /*Added for 8482224*/

Line 1767: pay_element_links_f pel,

1763: ,c_assignment_id IN NUMBER) IS
1764: SELECT pap.accrual_plan_id
1765: FROM pay_accrual_plans pap,
1766: pay_element_entries_f pee,
1767: pay_element_links_f pel,
1768: pay_element_types_f pet
1769: WHERE pel.element_link_id = pee.element_link_id
1770: AND pel.element_type_id = pet.element_type_id
1771: AND pee.assignment_id = c_assignment_id

Line 2465: ,pay_element_links_f pel

2461: sum(nvl(fnd_number.canonical_to_number(pev1.screen_entry_value),0))
2462: from
2463: pay_accrual_plans pap
2464: ,pay_element_types_f pet
2465: ,pay_element_links_f pel
2466: ,pay_input_values_f piv1
2467: ,pay_input_values_f piv2
2468: ,pay_element_entries_f pee
2469: ,pay_element_entry_values_f pev1

Line 2692: pay_element_links_f pel,

2688: is
2689: select min(PEE.EFFECTIVE_START_DATE)
2690: from pay_accrual_plans pap,
2691: pay_element_types_f pet,
2692: pay_element_links_f pel,
2693: pay_element_entries_f pee,
2694: per_assignments_f paf,
2695: per_periods_of_service pps
2696: where pee.element_link_id = pel.element_link_id