APPS.PAY_ELEMENT_TEMPLATE_UTIL dependencies on PAY_SHADOW_BALANCE_TYPES

Line 482: from pay_shadow_balance_types

478: category_name,
479: base_balance_type_id,
480: base_balance_name,
481: input_value_id
482: from pay_shadow_balance_types
483: where template_id = p_template_id
484: for update of balance_type_id;
485: begin
486: for crec in csr_balance_types(p_template_id) loop

Line 3322: , pay_shadow_balance_types bt

3318: where defined_balance_id in
3319: (
3320: select db.defined_balance_id
3321: from pay_shadow_defined_balances db
3322: , pay_shadow_balance_types bt
3323: where db.balance_type_id = bt.balance_type_id
3324: and bt.template_id = p_template_id
3325: );
3326: ----------------------------

Line 3338: from pay_shadow_balance_types

3334: delete from pay_shadow_gu_bal_exclusions
3335: where balance_type_id in
3336: (
3337: select balance_type_id
3338: from pay_shadow_balance_types
3339: where template_id = p_template_id
3340: );
3341: --------------------------------
3342: -- pay_shadow_ele_type_usages --

Line 3390: from pay_shadow_balance_types

3386: delete from pay_shadow_balance_classi
3387: where balance_type_id in
3388: (
3389: select balance_type_id
3390: from pay_shadow_balance_types
3391: where template_id = p_template_id
3392: );
3393: ---------------------------------
3394: -- pay_shadow_defined_balances --

Line 3400: from pay_shadow_balance_types

3396: delete from pay_shadow_defined_balances
3397: where balance_type_id in
3398: (
3399: select balance_type_id
3400: from pay_shadow_balance_types
3401: where template_id = p_template_id
3402: );
3403: ---------------------------------
3404: -- pay_shadow_sub_classi_rules --

Line 3414: -- pay_shadow_balance_types --

3410: from pay_shadow_element_types
3411: where template_id = p_template_id
3412: );
3413: ------------------------------
3414: -- pay_shadow_balance_types --
3415: ------------------------------
3416: --
3417: -- NULL the base_base_balance_type_id to avoid having to recursively
3418: -- delete because of the base_balance_type_id.

Line 3420: update pay_shadow_balance_types

3416: --
3417: -- NULL the base_base_balance_type_id to avoid having to recursively
3418: -- delete because of the base_balance_type_id.
3419: --
3420: update pay_shadow_balance_types
3421: set base_balance_type_id = null
3422: where base_balance_type_id is not null
3423: and template_id = p_template_id;
3424: --

Line 3425: delete from pay_shadow_balance_types

3421: set base_balance_type_id = null
3422: where base_balance_type_id is not null
3423: and template_id = p_template_id;
3424: --
3425: delete from pay_shadow_balance_types
3426: where template_id = p_template_id;
3427: -----------------------------
3428: -- pay_shadow_input_values --
3429: -----------------------------