DBA Data[Home] [Help]

APPS.OZF_FUND_EXTENSION_PVT dependencies on AMS_ACT_MARKET_SEGMENTS

Line 1006: DELETE FROM ams_act_market_segments

1002: );
1003: END IF;
1004:
1005: -- delete market segment data
1006: DELETE FROM ams_act_market_segments
1007: WHERE arc_act_market_segment_used_by = 'FUND'
1008: AND act_market_segment_used_by_id = p_object_id;
1009: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' market segment records with budget ' || l_fund_rec.short_name);
1010: IF SQL%ROWCOUNT > 0 THEN