APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_SYSTEM_PARAMETERS

Line 307: po_system_parameters_all psp

303:
304: SELECT ool.org_id
305: INTO l_org_id
306: FROM oe_order_headers_all ooh, oe_order_lines_all ool , po_requisition_lines_all prl ,
307: po_system_parameters_all psp
308: WHERE prl.requisition_header_id = nvl(p_req_hdr_id,prl.requisition_header_id)
309: AND p_req_line_id IS NOT null
310: AND prl.requisition_line_id = p_req_line_id
311: AND psp.org_id = prl.org_id

Line 324: po_system_parameters_all psp

320: INTO l_org_id
321: from po_requisition_lines_all prl,
322: po_requisition_headers_all prh,
323: oe_order_headers_all ooh,
324: po_system_parameters_all psp
325: WHERE prl.requisition_header_id = nvl(p_req_hdr_id,prh.requisition_header_id)
326: AND prl.requisition_line_id = nvl(p_req_line_id,prl.requisition_line_id)
327: AND prh.requisition_header_id = nvl(p_req_hdr_id,prh.requisition_header_id)
328: AND prh.requisition_header_id = ooh.source_document_id

Line 417: l_rate_type po_system_parameters.default_rate_type%TYPE;

413: x_amount_for_subject out nocopy varchar2,
414: x_amount_for_header out nocopy varchar2,
415: x_amount_for_tax out nocopy varchar2) is
416:
417: l_rate_type po_system_parameters.default_rate_type%TYPE;
418: l_rate number;
419: l_denominator_rate number;
420: l_numerator_rate number;
421: l_approval_currency varchar2(30);

Line 432: FROM po_system_parameters;

428:
429: begin
430: SELECT default_rate_type
431: INTO l_rate_type
432: FROM po_system_parameters;
433:
434: l_progress := 'getReqAmountInfo:' || l_rate_type;
435: IF (g_po_wf_debug = 'Y') THEN
436: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line 12843: from po_system_parameters;

12839: --12831835 Begin Added the foll code to get the cancelled qty for update
12840: BEGIN
12841: select order_source_id
12842: into X_order_source_id
12843: from po_system_parameters;
12844: EXCEPTION
12845: WHEN OTHERS THEN
12846: X_order_source_id :=NULL;
12847: END;