APPS.RCV_TRANSACTION_PROCESSOR dependencies on PO_LINE_LOCATIONS_ALL

Line 165: l_pll_approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE :='N';

161:
162: /*start of bug 13394743*/
163: l_po_auth_status PO_HEADERS_ALL.authorization_status%TYPE :='N';
164: l_po_approved_flag PO_HEADERS_ALL.approved_flag%TYPE :='N';
165: l_pll_approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE :='N';
166: l_po_unit_price PO_LINE_LOCATIONS_ALL.price_override%TYPE:=-1.0;
167: /*end of bug 13394743*/
168:
169: /*Bug 5517289-Start*/

Line 166: l_po_unit_price PO_LINE_LOCATIONS_ALL.price_override%TYPE:=-1.0;

162: /*start of bug 13394743*/
163: l_po_auth_status PO_HEADERS_ALL.authorization_status%TYPE :='N';
164: l_po_approved_flag PO_HEADERS_ALL.approved_flag%TYPE :='N';
165: l_pll_approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE :='N';
166: l_po_unit_price PO_LINE_LOCATIONS_ALL.price_override%TYPE:=-1.0;
167: /*end of bug 13394743*/
168:
169: /*Bug 5517289-Start*/
170: CURSOR c_fob_point (l_from_org_id NUMBER,l_to_org_id NUMBER)is

Line 228: from po_line_locations_all pll

224: where ph.po_header_id = l_rti_row.po_header_id;
225:
226: select nvl(approved_flag,'N') app_flag, nvl(price_override, -1.0) new_price
227: into l_pll_approved_flag, l_po_unit_price
228: from po_line_locations_all pll
229: where pll.line_location_id = l_rti_row.po_line_location_id;
230:
231: IF ( l_po_auth_status <> 'APPROVED' or l_po_approved_flag <> 'Y' or
232: l_pll_approved_flag <> 'Y' ) THEN