APPS.PO_AUTO_LINE_PROCESS_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 159: FROM financials_system_params_all req_fsp

155: l_progress := '010';
156:
157: SELECT req_fsp.set_of_books_id
158: INTO l_req_ou_sob_id
159: FROM financials_system_params_all req_fsp
160: WHERE req_fsp.org_id = p_requesting_ou_id;
161:
162: l_progress := '020';
163: SELECT po_fsp.set_of_books_id

Line 165: FROM financials_system_params_all po_fsp

161:
162: l_progress := '020';
163: SELECT po_fsp.set_of_books_id
164: INTO l_po_ou_sob_id
165: FROM financials_system_params_all po_fsp
166: WHERE po_fsp.org_id = p_purchasing_ou_id;
167:
168: IF l_req_ou_sob_id = l_po_ou_sob_id THEN
169: l_progress := '030';

Line 4806: -- Join to financials_system_params_all and gl_sets_of_books to

4802: PO_DEBUG.debug_stmt(l_log_head,l_progress,'p_interface_source_code IN (SOURCING, CONSUMPTION ADVICE) - no currency conversion performed');
4803:
4804: ELSE -- ( p_interface_source_code NOT IN ('SOURCING','CONSUMPTION_ADVICE') )
4805: -- Retrieve information from the backing Requisition Line.
4806: -- Join to financials_system_params_all and gl_sets_of_books to
4807: -- retrieve the value of l_req_ou_currency_code, the functional currency of ROU
4808: l_progress :='060';
4809: SELECT PRL.currency_code ,
4810: GSB.currency_code ,

Line 4822: financials_system_params_all FSP,

4818: l_req_currency_unit_price ,
4819: l_req_amount ,
4820: l_req_currency_amount
4821: FROM po_requisition_lines_all PRL,
4822: financials_system_params_all FSP,
4823: gl_sets_of_books GSB
4824: WHERE PRL.requisition_line_id = p_requisition_line_id
4825: AND NVL(PRL.org_id, -99) = NVL(FSP.org_id, -99)
4826: AND FSP.set_of_books_id = GSB.set_of_books_id;