APPS.QP_LIST_UPGRADE_UTIL_PVT dependencies on SO_PRICE_LISTS_B

Line 413: FROM so_price_lists_b prl

409: --DESCRIPTION,
410: PRICE_LIST_ID,
411: SECONDARY_PRICE_LIST_ID,
412: NULL
413: FROM so_price_lists_b prl
414: WHERE not exists ( select 'x'
415: from qp_discount_mapping dm
416: where dm.old_discount_id = prl.price_list_id
417: and dm.new_type in ('P','Z'))

Line 460: FROM SO_PRICE_LISTS_B PRL

456: --DESCRIPTION,
457: PRICE_LIST_ID,
458: SECONDARY_PRICE_LIST_ID,
459: 'AGR'
460: FROM SO_PRICE_LISTS_B PRL
461: WHERE PRL.PRICE_LIST_ID IN ( SELECT PRICE_LIST_ID
462: FROM SO_AGREEMENTS_B)
463: AND NOT EXISTS ( SELECT NULL
464: FROM QP_DISCOUNT_MAPPING

Line 470: FROM so_price_lists_b spl

466: AND NEW_TYPE = 'P');
467: vivek */
468: CURSOR sec_price_list IS
469: SELECT price_list_id, secondary_price_list_id
470: FROM so_price_lists_b spl
471: WHERE secondary_price_list_id is not null
472: and exists ( select list_header_id
473: from qp_LIST_headers_b
474: where list_header_id = spl.secondary_price_list_id )

Line 481: from so_price_lists_b spl

477: where list_header_id = spl.price_list_id );
478:
479: cursor invalid_sec is
480: select price_list_id, secondary_price_list_id
481: from so_price_lists_b spl
482: where secondary_price_list_id is not null
483: and secondary_price_list_id not in ( select list_header_id
484: from qp_LIST_headers_b );
485:

Line 488: from so_price_lists_b

484: from qp_LIST_headers_b );
485:
486: cursor invalid_prc is
487: select price_list_id
488: from so_price_lists_b
489: where price_list_id not in ( select list_header_id
490: from qp_LIST_headers_b );
491:
492:

Line 1537: FROM SO_PRICE_LISTS_B where secondary_price_list_id IS NOT NULL;

1533: vivek */
1534:
1535: CURSOR sec_prc_list IS
1536: SELECT DISTINCT secondary_price_list_id
1537: FROM SO_PRICE_LISTS_B where secondary_price_list_id IS NOT NULL;
1538:
1539: begin
1540:
1541: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,