APPS.PER_ABS_BUS dependencies on PAY_INPUT_VALUES_F

Line 115: pay_input_values_f piv

111: and pee.creator_type not in('A','EE','NR','PR','R','RR') -- Bug 4422696
112: and pee.element_type_id =
113: (select pet.element_type_id
114: from pay_element_types_f pet,
115: pay_input_values_f piv
116: where abt.input_value_id = piv.input_value_id
117: and piv.element_type_id = pet.element_type_id
118: and p_effective_date between piv.effective_start_date
119: and piv.effective_end_date

Line 962: pay_input_values_f piv

958: cursor c_get_absence_info is
959: select abt.hours_or_days,
960: piv.element_type_id
961: from per_absence_attendance_types abt,
962: pay_input_values_f piv
963: where abt.absence_attendance_type_id = p_absence_attendance_type_id
964: and abt.input_value_id = piv.input_value_id(+);
965: --
966: cursor c_get_normal_hours (p_assignment_id in number) is

Line 1965: pay_input_values_f piv,

1961: select pap.accrual_plan_id, asg.payroll_id
1962: from pay_element_entries_f pee,
1963: pay_element_links_f pel,
1964: pay_element_types_f pet,
1965: pay_input_values_f piv,
1966: per_all_assignments_f asg,
1967: per_absence_attendance_types abt,
1968: pay_accrual_plans pap
1969: where abt.absence_attendance_type_id = p_absence_attendance_type_id