DBA Data[Home] [Help]

APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_PRICE_ELEMENTS

Line 814: FROM pon_bid_price_elements_int bpfi, pon_price_elements apf

810: AND bli.line_number = bip.line_number
811: AND bip.display_price_factors_flag = 'Y'
812: AND EXISTS
813: (SELECT bpfi.price_element_name
814: FROM pon_bid_price_elements_int bpfi, pon_price_elements apf
815: WHERE apf.auction_header_id = p_auc_header_id
816: AND apf.line_number = bli.line_number
817: AND apf.pf_type = 'SUPPLIER'
818: AND bpfi.batch_id (+) = bli.batch_id

Line 833: FROM pon_price_elements apf

829: WHERE bpfi.batch_id = p_batch_id
830: AND bpfi.price_element_type_id <> g_error_int
831: AND 'BUYER' =
832: (SELECT apf.pf_type
833: FROM pon_price_elements apf
834: WHERE apf.auction_header_id = bpfi.auction_header_id
835: AND apf.line_number = bpfi.line_number
836: AND apf.price_element_type_id = bpfi.price_element_type_id);
837:

Line 2292: pon_price_elements apf

2288: AND bpei.line_number = bli.line_number
2289: AND EXISTS
2290: (SELECT bpfi.price_element_type_id
2291: FROM pon_bid_price_elements_int bpfi,
2292: pon_price_elements apf
2293: WHERE apf.auction_header_id = p_auction_header_id
2294: AND apf.line_number = bli.line_number
2295: AND apf.pf_type = 'SUPPLIER'
2296: AND bpfi.batch_id (+) = bli.batch_id