APPS.PO_NEGOTIATIONS_SV1 dependencies on PO_PRICE_DIFFERENTIALS

Line 386: FROM po_price_differentials

382: */ --
383:
384: CURSOR l_price_diff_csr ( p_req_line_id NUMBER ) IS
385: SELECT *
386: FROM po_price_differentials
387: WHERE entity_type = 'REQ LINE'
388: AND entity_id = p_req_line_id;
389: --
390: --

Line 1026: IF ( PO_PRICE_DIFFERENTIALS_PVT.has_price_differentials

1022: --
1023:
1024: -- Determine if this Requisition Line has Price Differentials.
1025: --
1026: IF ( PO_PRICE_DIFFERENTIALS_PVT.has_price_differentials
1027: ( p_entity_type => 'REQ LINE'
1028: , p_entity_id => x_req_line_id) --Bug 5841426
1029: )
1030: THEN

Line 2140: FROM po_price_differentials PD

2136: , PD.created_by
2137: , PD.last_update_date
2138: , PD.last_updated_by
2139: , PD.last_update_login
2140: FROM po_price_differentials PD
2141: , po_lines_all POL
2142: WHERE PD.entity_type = 'BLANKET LINE'
2143: AND PD.entity_id = POL.po_line_id
2144: AND POL.po_header_id = p_po_header_id;

Line 2176: FROM po_price_differentials PD

2172: , PD.created_by
2173: , PD.last_update_date
2174: , PD.last_updated_by
2175: , PD.last_update_login
2176: FROM po_price_differentials PD
2177: , po_lines_all POL
2178: , po_line_locations_all POLL
2179: WHERE PD.entity_type = 'PRICE BREAK'
2180: AND PD.entity_id = POLL.line_location_id

Line 2459: FROM po_price_differentials

2455: l_msg_data VARCHAR2(2000);
2456:
2457: CURSOR l_price_diff_csr ( p_req_line_id NUMBER ) IS
2458: SELECT *
2459: FROM po_price_differentials
2460: WHERE entity_type = 'REQ LINE'
2461: AND entity_id = p_req_line_id;
2462:
2463: l_conv_rate NUMBER;

Line 2890: IF ( PO_PRICE_DIFFERENTIALS_PVT.has_price_differentials

2886: --
2887:
2888: -- Determine if this Requisition Line has Price Differentials.
2889: --
2890: IF ( PO_PRICE_DIFFERENTIALS_PVT.has_price_differentials
2891: ( p_entity_type => 'REQ LINE'
2892: , p_entity_id => x_req_line_id) --Bug 5841426
2893: )
2894: THEN