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_INPUT_VALUES_F

Line 214: pay_input_values_f piv,

210: pay_element_entry_values_f peev,
211: pay_element_entry_values_f peev1,
212: pay_element_entry_values_f peev2,
213: pay_element_types_f pet,
214: pay_input_values_f piv,
215: pay_input_values_f piv1,
216: pay_input_values_f piv2
217: where pee.assignment_id = p_assignment_id
218: and pee.element_type_id = pet.element_type_id

Line 215: pay_input_values_f piv1,

211: pay_element_entry_values_f peev1,
212: pay_element_entry_values_f peev2,
213: pay_element_types_f pet,
214: pay_input_values_f piv,
215: pay_input_values_f piv1,
216: pay_input_values_f piv2
217: where pee.assignment_id = p_assignment_id
218: and pee.element_type_id = pet.element_type_id
219: and pet.element_name IN ('Statutory Paid Parental Leave Payment', 'Rec Statutory PPL Payment')

Line 216: pay_input_values_f piv2

212: pay_element_entry_values_f peev2,
213: pay_element_types_f pet,
214: pay_input_values_f piv,
215: pay_input_values_f piv1,
216: pay_input_values_f piv2
217: where pee.assignment_id = p_assignment_id
218: and pee.element_type_id = pet.element_type_id
219: and pet.element_name IN ('Statutory Paid Parental Leave Payment', 'Rec Statutory PPL Payment')
220: and pet.legislation_code = 'AU'

Line 224: pay_input_values_f piv

220: and pet.legislation_code = 'AU'
221: and peev.screen_entry_value = 'N'
222: and pee.element_entry_id = peev.element_entry_id
223: and pee.effective_start_date = (select Max(pe.effective_start_date) from pay_element_entries_f pe , pay_element_entry_values_f peev,
224: pay_input_values_f piv
225: where pe.assignment_id = p_assignment_id
226: and pee.element_entry_id= pe.element_entry_id
227: and peev.screen_entry_value = 'N'
228: and pe.element_entry_id = peev.element_entry_id

Line 1827: pay_input_values_f piv,

1823: ,c_assignment_id NUMBER) IS
1824: SELECT NVL(TO_DATE(pev.screen_entry_value,'YYYY/MM/DD HH24:MI:SS'),pps.date_start)
1825: FROM pay_element_entries_f pee,
1826: pay_element_entry_values_f pev,
1827: pay_input_values_f piv,
1828: pay_accrual_plans pap,
1829: hr_lookups hrl,
1830: per_assignments_f asg,
1831: per_periods_of_service pps

Line 2466: ,pay_input_values_f piv1

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
2470: ,pay_element_entry_values_f pev2

Line 2467: ,pay_input_values_f piv2

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
2470: ,pay_element_entry_values_f pev2
2471: where