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_ENTRY_VALUES_F

Line 210: pay_element_entry_values_f peev,

206: (to_date(peev1.screen_entry_value, 'YYYY/MM/DD HH24:MI:SS')) start_date,
207: (to_date(peev2.screen_entry_value, 'YYYY/MM/DD HH24:MI:SS')) end_date
208: from
209: pay_element_entries_f pee,
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,

Line 211: pay_element_entry_values_f peev1,

207: (to_date(peev2.screen_entry_value, 'YYYY/MM/DD HH24:MI:SS')) end_date
208: from
209: pay_element_entries_f pee,
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,

Line 212: pay_element_entry_values_f peev2,

208: from
209: pay_element_entries_f pee,
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

Line 223: and pee.effective_start_date = (select Max(pe.effective_start_date) from pay_element_entries_f pe , pay_element_entry_values_f peev,

219: and pet.element_name IN ('Statutory Paid Parental Leave Payment', 'Rec Statutory PPL Payment')
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'

Line 1826: pay_element_entry_values_f pev,

1822: ,c_calculation_date DATE
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,

Line 2469: ,pay_element_entry_values_f pev1

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
2472: pee.assignment_id = v_assignment_id
2473: and pet.element_name = v_initialise_type

Line 2470: ,pay_element_entry_values_f pev2

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
2472: pee.assignment_id = v_assignment_id
2473: and pet.element_name = v_initialise_type
2474: and pet.element_type_id = pel.element_type_id