DBA Data[Home] [Help]

APPS.PAY_SEED_UTL dependencies on PAY_INPUT_VALUES_F

Line 34: from pay_element_types_f e, pay_input_values_f i

30: CURSOR c_input_name_id(p_element_name VARCHAR2,
31: p_input_value_name VARCHAR2,
32: p_legislation_code VARCHAR2) IS
33: select i.input_value_id
34: from pay_element_types_f e, pay_input_values_f i
35: where e.element_name = p_element_name
36: and i.name = p_input_value_name
37: and i.element_type_id = e.element_type_id
38: and i.legislation_code = p_legislation_code

Line 250: from pay_element_types_f e, pay_input_values_f i

246: CURSOR c_input_name_id(p_element_name VARCHAR2,
247: p_input_value_name VARCHAR2,
248: p_legislation_code VARCHAR2) IS
249: select i.input_value_id
250: from pay_element_types_f e, pay_input_values_f i
251: where e.element_name = p_element_name
252: and i.name = p_input_value_name
253: and i.element_type_id = e.element_type_id
254: and i.legislation_code = p_legislation_code