APPS.AMS_ACT_MARKET_SEGMENTS_PVT dependencies on QP_QUALIFIERS

Line 1376: FROM qp_qualifiers

1372: )
1373: IS
1374: CURSOR c_mkt_seg_id(l_id NUMBER) IS
1375: SELECT COUNT(1)
1376: FROM qp_qualifiers
1377: WHERE qualifier_id = l_id;
1378:
1379: l_mks_used_by_id NUMBER ;
1380: l_mks_used_by VARCHAR2(30) ;

Line 1501: -- from qp_qualifiers

1497: */END IF;
1498:
1499: -- added by julou on MAY-01-2001
1500: -- if segment type is 'QUALIFIER', market_segment_id must be qualifier_id
1501: -- from qp_qualifiers
1502: /* removed by julou. no segment type any more.
1503: IF p_mks_rec.segment_type = 'QUALIFIER' THEN
1504: OPEN c_mkt_seg_id(p_mks_rec.market_segment_id);
1505: FETCH c_mkt_seg_id INTO l_dummy;