DBA Data[Home] [Help]

APPS.OE_PRICING_CONT_PVT dependencies on QP_LIST_HEADERS_VL

Line 572: qp_list_headers_vl where

568: /*Changes made by spgopal for AGR fix conditionally create qualifiers 08/14/00*/
569:
570: begin --Begin, Exception and End stmts added for OKC
571: select list_type_code into l_price_list_type_code from
572: qp_list_headers_vl where
573: list_header_id = l_Agreement_rec.price_list_id;
574: exception
575: when others then
576: l_price_list_type_code := NULL;

Line 617: qp_list_headers_vl where

613: /*Changes made by spgopal for AGR fix conditionally create qualifiers 08/14/00*/
614:
615: begin --Begin, Exception and End added for OKC
616: select list_type_code into l_price_list_type_code from
617: qp_list_headers_vl where
618: list_header_id = l_Agreement_rec.price_list_id;
619: exception
620: when others then
621: l_price_list_type_code := NULL;

Line 656: qp_list_headers_vl where

652: /*Changes made by spgopal for AGR fix conditionally create qualifiers 08/10/00*/
653:
654: /*
655: select list_type_code into l_price_list_type_code from
656: qp_list_headers_vl where
657: list_header_id = l_Agreement_rec.price_list_id;
658:
659:
660: IF l_price_list_type_code = 'AGR' THEN