APPS.PAY_ELEMENT_TEMPLATE_UTIL dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 426: from pay_shadow_element_types

422: proration_formula,
423: recalc_event_group,
424: once_each_period_flag,
425: object_version_number
426: from pay_shadow_element_types
427: where template_id = p_template_id
428: for update of element_type_id;
429: begin
430: for crec in csr_element_types(p_template_id) loop

Line 510: , pay_shadow_element_types et

506: , f.formula_text
507: , f.formula_type_name
508: , f.object_version_number
509: from pay_shadow_formulas f
510: , pay_shadow_element_types et
511: where et.template_id = p_template_id
512: and et.payroll_formula_id is not null
513: and f.formula_id = et.payroll_formula_id
514: for update of f.formula_id;

Line 527: , pay_shadow_element_types et

523: , f.formula_text
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

Line 1752: fnd_message.set_token('TABLE', 'PAY_SHADOW_ELEMENT_TYPES');

1748: -- A formula usage has already been applied to this element. This
1749: -- means that the exclusion rules were not applied correctly.
1750: --
1751: fnd_message.set_name(801, 'PAY_50206_MULTIPLE_FF_USAGES');
1752: fnd_message.set_token('TABLE', 'PAY_SHADOW_ELEMENT_TYPES');
1753: fnd_message.raise_error;
1754: else
1755: p_element_types(j).payroll_formula_id :=
1756: p_template_ff_usages(i).formula_id;

Line 3348: from pay_shadow_element_types

3344: delete from pay_shadow_ele_type_usages
3345: where element_type_id in
3346: (
3347: select element_type_id
3348: from pay_shadow_element_types
3349: where template_id = p_template_id
3350: );
3351: --------------------------------
3352: -- pay_shadow_iterative_rules --

Line 3358: from pay_shadow_element_types

3354: delete from pay_shadow_iterative_rules
3355: where element_type_id in
3356: (
3357: select element_type_id
3358: from pay_shadow_element_types
3359: where template_id = p_template_id
3360: );
3361: ------------------------------
3362: -- pay_shadow_formula_rules --

Line 3368: from pay_shadow_element_types

3364: delete from pay_shadow_formula_rules
3365: where shadow_element_type_id in
3366: (
3367: select element_type_id
3368: from pay_shadow_element_types
3369: where template_id = p_template_id
3370: );
3371: ------------------------------
3372: -- pay_shadow_balance_feeds --

Line 3379: , pay_shadow_element_types et

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: );
3383: --------------------------------

Line 3410: from pay_shadow_element_types

3406: delete from pay_shadow_sub_classi_rules
3407: where element_type_id in
3408: (
3409: select element_type_id
3410: from pay_shadow_element_types
3411: where template_id = p_template_id
3412: );
3413: ------------------------------
3414: -- pay_shadow_balance_types --

Line 3434: from pay_shadow_element_types

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
3435: where template_id = p_template_id
3436: );
3437: ------------------------------
3438: -- pay_shadow_element_types --

Line 3438: -- pay_shadow_element_types --

3434: from pay_shadow_element_types
3435: where template_id = p_template_id
3436: );
3437: ------------------------------
3438: -- pay_shadow_element_types --
3439: ------------------------------
3440: delete from pay_shadow_element_types
3441: where template_id = p_template_id;
3442: -------------------------

Line 3440: delete from pay_shadow_element_types

3436: );
3437: ------------------------------
3438: -- pay_shadow_element_types --
3439: ------------------------------
3440: delete from pay_shadow_element_types
3441: where template_id = p_template_id;
3442: -------------------------
3443: -- pay_shadow_formulas --
3444: -------------------------