DBA Data[Home] [Help]

APPS.HR_AU_HOLIDAYS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 604: pay_element_entry_values_f pev,

600: ,c_calculation_date DATE
601: ,c_assignment_id NUMBER) IS
602: SELECT NVL(TO_DATE(pev.screen_entry_value,'YYYY/MM/DD HH24:MI:SS'),pps.date_start)
603: FROM pay_element_entries_f pee,
604: pay_element_entry_values_f pev,
605: pay_input_values_f piv,
606: pay_accrual_plans pap,
607: hr_lookups hrl,
608: per_assignments_f asg,

Line 1247: ,pay_element_entry_values_f pev1

1243: ,pay_element_links_f pel
1244: ,pay_input_values_f piv1
1245: ,pay_input_values_f piv2
1246: ,pay_element_entries_f pee
1247: ,pay_element_entry_values_f pev1
1248: ,pay_element_entry_values_f pev2
1249: where
1250: pee.assignment_id = v_assignment_id
1251: and pet.element_name = v_initialise_type

Line 1248: ,pay_element_entry_values_f pev2

1244: ,pay_input_values_f piv1
1245: ,pay_input_values_f piv2
1246: ,pay_element_entries_f pee
1247: ,pay_element_entry_values_f pev1
1248: ,pay_element_entry_values_f pev2
1249: where
1250: pee.assignment_id = v_assignment_id
1251: and pet.element_name = v_initialise_type
1252: and pet.element_type_id = pel.element_type_id