APPS.HR_TEMPLATE_EXISTENCE dependencies on PAY_INPUT_VALUES_F

Line 296: FROM pay_input_values_f piv

292: hr_utility.set_location('hr_template_existence.iv_name_exists',10);
293:
294: SELECT piv.input_value_id
295: INTO already_exists
296: FROM pay_input_values_f piv
297: WHERE piv.name = p_iv_name
298: AND piv.element_type_id = p_ele_id
299: AND piv.business_group_id = p_bg_id
300: AND p_eff_date between piv.effective_start_date and piv.effective_end_date;