APPS.PO_PALT_MS_COMPLETION dependencies on PON_AUCTION_HEADERS_ALL

Line 39: PON_AUCTION_HEADERS_ALL PAHA

35: SELECT DECODE(val,TO_DATE('31.12.9999 23:59:59', 'dd.mm.yyyy hh24:mi:ss'), to_date(NULL), val) INTO L_Solicit_Publish_Dt
36: FROM ( SELECT MAX(NVL(PUBLISH_DATE, TO_DATE('31.12.9999 23:59:59', 'dd.mm.yyyy hh24:mi:ss'))) val
37: FROM PO_REQUISITION_LINES_ALL PRLA,
38: PON_BACKING_REQUISITIONS PBR ,
39: PON_AUCTION_HEADERS_ALL PAHA
40: WHERE PRLA.REQUISITION_LINE_ID = PBR.REQUISITION_LINE_ID(+)
41: AND NVL(PRLA.CLM_INFO_FLAG,'N') <> 'Y'
42: AND PBR.AUCTION_HEADER_ID = PAHA.AUCTION_HEADER_ID (+)
43: AND PAHA.AUCTION_STATUS (+) = 'ACTIVE'