DBA Data[Home] [Help]

APPS.PER_ABSENCE_ATTENDANCES_PKG3 dependencies on PAY_INPUT_VALUES_F

Line 177: pay_input_values_f piv

173: cursor c1 is
174: select piv.element_type_id,
175: abt.hours_or_days
176: from per_absence_attendance_types abt,
177: pay_input_values_f piv
178: where abt.absence_attendance_type_id = p_abs_type_id
179: and abt.input_value_id = piv.input_value_id
180: and p_date_start between piv.effective_start_date
181: and piv.effective_end_date;

Line 892: FROM pay_input_values_f iv,

888: select iv.element_type_id,
889: a.hours_or_days,
890: a.increasing_or_decreasing_flag,
891: a.input_value_id
892: FROM pay_input_values_f iv,
893: per_absence_attendance_types a
894: WHERE a.absence_attendance_type_id = p_absence_att_type_id
895: AND a.input_value_id = iv.input_value_id (+);
896: */