DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TEMPLATE_UTIL dependencies on PAY_SHADOW_ELE_TYPE_USAGES

Line 937: from pay_shadow_ele_type_usages

933: inclusion_flag,
934: run_type_name,
935: exclusion_rule_id,
936: object_version_number
937: from pay_shadow_ele_type_usages
938: where element_type_id = p_element_type_id
939: for update of element_type_usage_id;
940: begin
941: --

Line 3342: -- pay_shadow_ele_type_usages --

3338: from pay_shadow_balance_types
3339: where template_id = p_template_id
3340: );
3341: --------------------------------
3342: -- pay_shadow_ele_type_usages --
3343: --------------------------------
3344: delete from pay_shadow_ele_type_usages
3345: where element_type_id in
3346: (

Line 3344: delete from pay_shadow_ele_type_usages

3340: );
3341: --------------------------------
3342: -- pay_shadow_ele_type_usages --
3343: --------------------------------
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