APPS.PAY_ELEMENT_TEMPLATE_UTIL dependencies on PAY_SHADOW_INPUT_VALUES

Line 528: , pay_shadow_input_values iv

524: , f.formula_type_name
525: , f.object_version_number
526: from pay_shadow_formulas f
527: , pay_shadow_element_types et
528: , pay_shadow_input_values iv
529: where et.template_id = p_template_id
530: and et.element_type_id = iv.element_type_id
531: and iv.formula_id is not null
532: and f.formula_id = iv.formula_id

Line 755: from pay_shadow_input_values

751: exclusion_rule_id,
752: formula_id,
753: input_validation_formula,
754: object_version_number
755: from pay_shadow_input_values
756: where element_type_id = p_element_type_id
757: for update of input_value_id;
758: begin
759: --

Line 3378: from pay_shadow_input_values iv

3374: delete from pay_shadow_balance_feeds
3375: where input_value_id in
3376: (
3377: select iv.input_value_id
3378: from pay_shadow_input_values iv
3379: , pay_shadow_element_types et
3380: where et.template_id = p_template_id
3381: and iv.element_type_id = et.element_type_id
3382: );

Line 3428: -- pay_shadow_input_values --

3424: --
3425: delete from pay_shadow_balance_types
3426: where template_id = p_template_id;
3427: -----------------------------
3428: -- pay_shadow_input_values --
3429: -----------------------------
3430: delete from pay_shadow_input_values
3431: where element_type_id in
3432: (

Line 3430: delete from pay_shadow_input_values

3426: where template_id = p_template_id;
3427: -----------------------------
3428: -- pay_shadow_input_values --
3429: -----------------------------
3430: delete from pay_shadow_input_values
3431: where element_type_id in
3432: (
3433: select element_type_id
3434: from pay_shadow_element_types