DBA Data[Home] [Help]

APPS.PAY_US_EMP_BALADJ_CLEANUP dependencies on PAY_INPUT_VALUES_F

Line 146: from pay_input_values_f piv

142: cursor c_get_input_id (cp_element_type_id in number
143: ,cp_input_value_name in varchar2
144: ,cp_effective_date in date) is
145: select input_value_id
146: from pay_input_values_f piv
147: where piv.element_type_id = cp_element_type_id
148: and piv.legislation_code = 'US'
149: and piv.name = cp_input_value_name
150: and cp_effective_date between piv.effective_start_date