APPS.PER_ABS_BUS dependencies on PAY_INPUT_VALUES_F

Line 116: pay_input_values_f piv

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

Line 966: pay_input_values_f piv

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

Line 1131: pay_input_values_f piv

1127: cursor c_get_absence_info is
1128: select abt.hours_or_days,
1129: piv.element_type_id
1130: from per_absence_attendance_types abt,
1131: pay_input_values_f piv
1132: where abt.absence_attendance_type_id = p_absence_attendance_type_id
1133: and abt.input_value_id = piv.input_value_id(+);
1134: --
1135: cursor c_get_normal_hours (p_assignment_id in number) is

Line 2307: pay_input_values_f piv,

2303: select pap.accrual_plan_id, asg.payroll_id
2304: from pay_element_entries_f pee,
2305: pay_element_links_f pel,
2306: pay_element_types_f pet,
2307: pay_input_values_f piv,
2308: per_all_assignments_f asg,
2309: per_absence_attendance_types abt,
2310: pay_accrual_plans pap
2311: where abt.absence_attendance_type_id = p_absence_attendance_type_id