APPS.POR_RCV_POST_QUERY_PKG dependencies on PO_CLMREQ_LINE_AWD_REFS_V

Line 175: select distinct CLM_DOCUMENT_NUMBER into xOrderNumber from PO_CLMREQ_LINE_AWD_REFS_V where requisition_header_id=pReqHeaderId ;

171: xOrderNumber VARCHAR2(50);
172: BEGIN
173:
174: IF pFederalFlag = 'Y' THEN
175: select distinct CLM_DOCUMENT_NUMBER into xOrderNumber from PO_CLMREQ_LINE_AWD_REFS_V where requisition_header_id=pReqHeaderId ;
176: ELSE
177: SELECT ORDER_NUM
178: INTO xOrderNumber
179: FROM (

Line 215: (select DISTINCT PV.VENDOR_NAME SUPPLIER FROM PO_CLMREQ_LINE_AWD_REFS_V PH, PO_VENDORS PV

211: BEGIN
212:
213: IF pFederalFlag = 'Y' THEN
214: select SUPPLIER into xSupplier from
215: (select DISTINCT PV.VENDOR_NAME SUPPLIER FROM PO_CLMREQ_LINE_AWD_REFS_V PH, PO_VENDORS PV
216: where PH.VENDOR_ID = PV.VENDOR_ID AND PH.requisition_header_id=pReqHeaderId );
217: ELSE
218: SELECT SUPPLIER
219: INTO xSupplier