DBA Data[Home] [Help]

APPS.OZF_FUND_EXTENSION_PVT dependencies on AMS_ACT_MARKET_SEGMENTS

Line 983: DELETE FROM ams_act_market_segments

979: );
980: END IF;
981:
982: -- delete market segment data
983: DELETE FROM ams_act_market_segments
984: WHERE arc_act_market_segment_used_by = 'FUND'
985: AND act_market_segment_used_by_id = p_object_id;
986: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' market segment records with budget ' || l_fund_rec.short_name);
987: IF SQL%ROWCOUNT > 0 THEN