APPS.HR_NZ_HOLIDAYS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1107: pay_element_entry_values_f pev,

1103: ,c_calculation_date DATE
1104: ,c_assignment_id NUMBER) IS
1105: SELECT NVL(TO_DATE(pev.screen_entry_value,'YYYY/MM/DD HH24:MI:SS'),pps.date_start)
1106: FROM pay_element_entries_f pee,
1107: pay_element_entry_values_f pev,
1108: pay_input_values_f piv,
1109: pay_accrual_plans pap,
1110: per_all_assignments_f asg,
1111: per_periods_of_service pps

Line 2101: , pay_element_entry_values_f eev -- absence element entry

2097: ,p_year_end_date date) is
2098: select ab.absence_hours absence_hours
2099: , to_number(rrv2.result_value) absence_pay
2100: from pay_accrual_plans ap -- annual leave accrualplan
2101: , pay_element_entry_values_f eev -- absence element entry
2102: -- "hours taken" entry value
2103: , pay_element_entries_f ee -- absence element entry
2104: , pay_run_results rr -- run result for absence -- element entry
2105: , per_absence_attendances ab -- absence record

Line 3758: ,pay_element_entry_values_f pev1

3754: ,pay_element_links_f pel
3755: ,pay_input_values_f piv1
3756: ,pay_input_values_f piv2
3757: ,pay_element_entries_f pee
3758: ,pay_element_entry_values_f pev1
3759: ,pay_element_entry_values_f pev2
3760: where
3761: pee.assignment_id = v_assignment_id
3762: and pet.element_name = v_adjustment_element

Line 3759: ,pay_element_entry_values_f pev2

3755: ,pay_input_values_f piv1
3756: ,pay_input_values_f piv2
3757: ,pay_element_entries_f pee
3758: ,pay_element_entry_values_f pev1
3759: ,pay_element_entry_values_f pev2
3760: where
3761: pee.assignment_id = v_assignment_id
3762: and pet.element_name = v_adjustment_element
3763: and pet.element_type_id = pel.element_type_id