DBA Data[Home] [Help]

APPS.BEN_PDW_MASS_UPD_RATES dependencies on PAY_INPUT_VALUES_F

Line 204: pay_input_values_f_tl pivt,

200: begin
201: select
202: pivt.input_value_id into l_input_value_id
203: from
204: pay_input_values_f_tl pivt,
205: pay_input_values_f piv
206: where
207: pivt.name = p_input_value_id
208: and piv.element_type_id = p_element_type_id

Line 205: pay_input_values_f piv

201: select
202: pivt.input_value_id into l_input_value_id
203: from
204: pay_input_values_f_tl pivt,
205: pay_input_values_f piv
206: where
207: pivt.name = p_input_value_id
208: and piv.element_type_id = p_element_type_id
209: and p_effective_date between piv.effective_start_date and piv.effective_end_date