APPS.PO_PALT_MS_COMPLETION dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 13: PON_AUCTION_ITEM_PRICES_ALL PAIP

9: SELECT DECODE(val,TO_DATE('31.12.9999 23:59:59', 'dd.mm.yyyy hh24:mi:ss'), to_date(NULL), val) INTO L_Solicit_Creation_Dt
10: FROM ( SELECT MAX(NVL(PAIP.CREATION_DATE, TO_DATE('31.12.9999 23:59:59', 'dd.mm.yyyy hh24:mi:ss'))) val
11: FROM PO_REQUISITION_LINES_ALL PRL,
12: PON_BACKING_REQUISITIONS PBR,
13: PON_AUCTION_ITEM_PRICES_ALL PAIP
14: WHERE PRL.REQUISITION_LINE_ID = PBR.REQUISITION_LINE_ID (+)
15: AND NVL(PRL.CLM_INFO_FLAG,'N') <> 'Y'
16: AND PBR.AUCTION_HEADER_ID = PAIP.AUCTION_HEADER_ID (+)
17: AND PBR.LINE_NUMBER = PAIP.LINE_NUMBER (+)