APPS.POR_AMENDMENT_PKG dependencies on PO_CLMREQ_LINE_AWD_REFS_V

Line 5211: PO_CLMREQ_LINE_AWD_REFS_V awdrefs

5207:
5208: SELECT Min(awdrefs.agent_id)
5209: INTO l_buyer_id
5210: FROM po_requisition_lines_all prl,
5211: PO_CLMREQ_LINE_AWD_REFS_V awdrefs
5212: -- po_line_locations_all pll,
5213: -- po_headers_all pha
5214: WHERE prl.requisition_header_id = (SELECT conformed_header_id
5215: FROM po_requisition_headers_all

Line 5527: select 'Y' into isApprovedPOLine from PO_CLMREQ_LINE_AWD_REFS_V WHERE requisition_line_id= reqLineId

5523:
5524: IF l_line_location_id IS NOT NULL THEN
5525: IF l_line_location_id < 0 THEN
5526: BEGIN
5527: select 'Y' into isApprovedPOLine from PO_CLMREQ_LINE_AWD_REFS_V WHERE requisition_line_id= reqLineId
5528: AND nvl(authorization_status,'INCOMPLETE') ='APPROVED' AND ROWNUM=1;
5529: EXCEPTION
5530: WHEN No_Data_Found THEN
5531: isApprovedPOLine :='N';

Line 8287: FROM po_clmreq_line_awd_refs_v

8283: IF(l_req_cnt = 0) THEN
8284:
8285: SELECT Count(*)
8286: INTO l_po_cnt
8287: FROM po_clmreq_line_awd_refs_v
8288: WHERE requisition_header_id = l_req_header_id
8289: AND Nvl(authorization_status,'INCOMPLETE') NOT IN ('APPROVED','REJECTED','CANCELLED');
8290:
8291: IF(l_po_cnt >0) THEN