DBA Data[Home] [Help]

APPS.PAY_FORMULA_RESULT_RULES_PKG dependencies on PAY_INPUT_VALUES_F

Line 178: from pay_input_values_f_tl ipv_tl,

174: v_input_value_id number(10);
175: --
176: cursor csr_input_value is
177: select ipv.input_value_id
178: from pay_input_values_f_tl ipv_tl,
179: pay_input_values_f ipv
180: where ipv_tl.input_value_id = ipv.input_value_id
181: and userenv('LANG') = ipv_tl.language
182: and ipv.element_type_id = p_element_type_id

Line 179: pay_input_values_f ipv

175: --
176: cursor csr_input_value is
177: select ipv.input_value_id
178: from pay_input_values_f_tl ipv_tl,
179: pay_input_values_f ipv
180: where ipv_tl.input_value_id = ipv.input_value_id
181: and userenv('LANG') = ipv_tl.language
182: and ipv.element_type_id = p_element_type_id
183: and ipv_tl.name = v_pay_value

Line 450: 'PAY_INPUT_VALUES_F',input_value_id)

446: from pay_formula_result_rules_f
447: where p_parent_id = decode (p_parent_name,
448: 'PAY_STATUS_PROCESSING_RULES_F',status_processing_rule_id,
449: 'PAY_ELEMENT_TYPES_F',element_type_id,
450: 'PAY_INPUT_VALUES_F',input_value_id)
451: for update;
452: --
453: begin
454: hr_utility.set_location ('pay_sub_class_rules_pkg.parent_deleted',1);