DBA Data[Home] [Help]

APPS.BEN_PD_COPY_TO_BEN_FIVE dependencies on PAY_INPUT_VALUES_F

Line 197: from pay_input_values_f

193: and p_effective_date between Effective_Start_Date and Effective_End_Date;
194: --
195: cursor c_input_values(p_inpt_old_name varchar2, p_elm_new_id number) is
196: select input_value_id
197: from pay_input_values_f
198: where name = p_inpt_old_name
199: and element_type_id = p_elm_new_id
200: and business_group_id is null
201: and p_effective_date between Effective_Start_Date and Effective_End_Date;

Line 13776: from pay_input_values_f

13772: c_input_value_name in varchar2,
13773: c_business_group_id in number,
13774: c_effective_date in date) is
13775: select input_value_id
13776: from pay_input_values_f
13777: where name = c_input_value_name
13778: and element_type_id = c_element_type_id
13779: and (business_group_id is null or business_group_id = c_business_group_id)
13780: and c_effective_date between effective_start_date