APPS.AMS_MKT_SEGMENTS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21

  SELECT a.market_segment_id, a.act_market_segment_used_by_id
    FROM ams_act_market_segments a,
	     ams_party_market_segments b
   WHERE b.party_id = c_party_id
     AND b.market_segment_id = a.market_segment_id
	 -- AND b.market_segment_flag = 'N'
	 AND a.arc_act_market_segment_used_by = 'CAMP';

Line: 31

   SELECT a.market_segment_id, a.act_market_segment_used_by_id
     FROM ams_act_market_segments a
	WHERE a.market_segment_id = c_target_id
	  AND a.arc_act_market_segment_used_by = 'CAMP';

Line: 39

  SELECT a.market_segment_id, a.act_market_segment_used_by_id
    FROM ams_act_market_segments a,
	     ams_party_market_segments b
   WHERE b.party_id = c_party_id
     AND b.market_segment_id = c_target_id
	 AND b.market_segment_id = a.market_segment_id
	 -- AND b.market_segment_flag = 'N'
     AND a.arc_act_market_segment_used_by = 'CAMP';