APPS.PO_PALT_MS_COMPLETION dependencies on PON_BACKING_REQUISITIONS

Line 12: PON_BACKING_REQUISITIONS PBR,

8:
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 (+)

Line 38: PON_BACKING_REQUISITIONS PBR ,

34:
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 (+)