DBA Data[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on PON_PRICE_DIFFERENTIALS

Line 663: FROM pon_price_differentials apd

659: p_userid, -- CREATED_BY
660: sysdate, -- LAST_UPDATE_DATE
661: p_userid, -- LAST_UPDATED_BY
662: null -- LAST_UPDATE_LOGIN
663: FROM pon_price_differentials apd
664: WHERE apd.auction_header_id = p_auc_header_id
665: AND apd.line_number BETWEEN p_batch_start AND p_batch_end
666: AND NOT EXISTS
667: (SELECT pbpd.price_differential_number

Line 2064: FROM pon_price_differentials apd,

2060: sysdate, -- LAST_UPDATE_DATE
2061: p_userid, -- LAST_UPDATED_BY
2062: null, -- LAST_UPDATE_LOGIN
2063: decode(p_rebid_flag, 'Y', bpd.multiplier, null) -- OLD_MULTIPLIER
2064: FROM pon_price_differentials apd,
2065: pon_bid_price_differentials bpd,
2066: pon_bid_item_prices bl
2067: WHERE apd.auction_header_id = p_auc_header_id
2068: AND apd.shipment_number = -1 -- only line level differentials

Line 2096: FROM pon_price_differentials apd,

2092: sysdate, -- LAST_UPDATE_DATE
2093: p_userid, -- LAST_UPDATED_BY
2094: null, -- LAST_UPDATE_LOGIN
2095: decode(p_rebid_flag, 'Y', bpd.multiplier, null) -- OLD_MULTIPLIER
2096: FROM pon_price_differentials apd,
2097: pon_bid_price_differentials bpd,
2098: pon_bid_shipments bpb,
2099: pon_bid_item_prices bl
2100: WHERE apd.auction_header_id = p_auc_header_id