DBA Data[Home] [Help]

APPS.PAY_ELE_SHD dependencies on PAY_INPUT_VALUES_F

Line 726: FROM pay_input_values_f piv

722: --
723: CURSOR C_Lookup IS
724: SELECT piv.lookup_type,
725: piv.value_set_id
726: FROM pay_input_values_f piv
727: WHERE piv.input_value_id = p_input_value_id
728: AND nvl(p_effective_date,sysdate)
729: between piv.effective_start_date
730: and piv.effective_end_date;