DBA Data[Home] [Help]

APPS.OZF_PRICELIST_PVT dependencies on AMS_ACT_MKT_SEGMENTS_VL

Line 939: FROM ams_act_mkt_segments_vl aam

935: l_api_version CONSTANT NUMBER := 1.0;
936:
937: CURSOR cur_get_market_segments IS
938: SELECT aam.market_segment_name
939: FROM ams_act_mkt_segments_vl aam
940: WHERE aam.act_market_segment_used_by_id = p_price_list_id
941: AND aam.arc_act_market_segment_used_by ='PRIC'
942: AND aam.segment_type = 'MARKET_SEGMENT';
943:

Line 946: FROM ams_act_mkt_segments_vl aam

942: AND aam.segment_type = 'MARKET_SEGMENT';
943:
944: CURSOR cur_get_target_segments IS
945: SELECT aam.market_segment_name
946: FROM ams_act_mkt_segments_vl aam
947: WHERE aam.act_market_segment_used_by_id = p_price_list_id
948: AND aam.arc_act_market_segment_used_by = 'PRIC'
949: AND aam.segment_type = 'CELL';
950: