DBA Data[Home] [Help]

APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_PRICE_ELEMENTS

Line 737: FROM pon_bid_price_elements_int bpfi, pon_price_elements apf

733: AND bli.line_number = bip.line_number
734: AND bip.display_price_factors_flag = 'Y'
735: AND EXISTS
736: (SELECT bpfi.price_element_name
737: FROM pon_bid_price_elements_int bpfi, pon_price_elements apf
738: WHERE apf.auction_header_id = p_auc_header_id
739: AND apf.line_number = bli.line_number
740: AND apf.pf_type = 'SUPPLIER'
741: AND bpfi.batch_id (+) = bli.batch_id

Line 756: FROM pon_price_elements apf

752: WHERE bpfi.batch_id = p_batch_id
753: AND bpfi.price_element_type_id <> g_error_int
754: AND 'BUYER' =
755: (SELECT apf.pf_type
756: FROM pon_price_elements apf
757: WHERE apf.auction_header_id = bpfi.auction_header_id
758: AND apf.line_number = bpfi.line_number
759: AND apf.price_element_type_id = bpfi.price_element_type_id);
760:

Line 2079: pon_price_elements apf

2075: AND bpei.line_number = bli.line_number
2076: AND EXISTS
2077: (SELECT bpfi.price_element_type_id
2078: FROM pon_bid_price_elements_int bpfi,
2079: pon_price_elements apf
2080: WHERE apf.auction_header_id = p_auction_header_id
2081: AND apf.line_number = bli.line_number
2082: AND apf.pf_type = 'SUPPLIER'
2083: AND bpfi.batch_id (+) = bli.batch_id