APPS.PAY_ELEMENT_TEMPLATE_UTIL dependencies on PAY_SHADOW_DEFINED_BALANCES

Line 655: from pay_shadow_defined_balances

651: force_latest_balance_flag,
652: grossup_allowed_flag,
653: object_version_number,
654: exclusion_rule_id
655: from pay_shadow_defined_balances
656: where balance_type_id = p_balance_type_id
657: for update of defined_balance_id;
658: begin
659: --

Line 3321: from pay_shadow_defined_balances db

3317: delete from pay_shadow_bal_attributes
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: );

Line 3394: -- pay_shadow_defined_balances --

3390: from pay_shadow_balance_types
3391: where template_id = p_template_id
3392: );
3393: ---------------------------------
3394: -- pay_shadow_defined_balances --
3395: ---------------------------------
3396: delete from pay_shadow_defined_balances
3397: where balance_type_id in
3398: (

Line 3396: delete from pay_shadow_defined_balances

3392: );
3393: ---------------------------------
3394: -- pay_shadow_defined_balances --
3395: ---------------------------------
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