DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TEMPLATE_UTIL dependencies on PAY_SHADOW_SUB_CLASSI_RULES

Line 846: from pay_shadow_sub_classi_rules

842: element_type_id,
843: element_classification,
844: object_version_number,
845: exclusion_rule_id
846: from pay_shadow_sub_classi_rules
847: where element_type_id = p_element_type_id
848: for update of sub_classification_rule_id;
849: begin
850: --

Line 3404: -- pay_shadow_sub_classi_rules --

3400: from pay_shadow_balance_types
3401: where template_id = p_template_id
3402: );
3403: ---------------------------------
3404: -- pay_shadow_sub_classi_rules --
3405: ---------------------------------
3406: delete from pay_shadow_sub_classi_rules
3407: where element_type_id in
3408: (

Line 3406: delete from pay_shadow_sub_classi_rules

3402: );
3403: ---------------------------------
3404: -- pay_shadow_sub_classi_rules --
3405: ---------------------------------
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