APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_SYSTEM_PARAMETERS

Line 308: po_system_parameters_all psp

304: INTO l_org_id
305: from po_requisition_lines_all prl,
306: po_requisition_headers_all prh,
307: oe_order_headers_all ooh,
308: po_system_parameters_all psp
309: WHERE prl.requisition_header_id = nvl(p_req_hdr_id,prh.requisition_header_id)
310: AND prl.requisition_line_id = nvl(p_req_line_id,prl.requisition_line_id)
311: AND prh.requisition_header_id = nvl(p_req_hdr_id,prh.requisition_header_id)
312: AND prh.requisition_header_id = ooh.source_document_id

Line 400: l_rate_type po_system_parameters.default_rate_type%TYPE;

396: x_amount_for_subject out nocopy varchar2,
397: x_amount_for_header out nocopy varchar2,
398: x_amount_for_tax out nocopy varchar2) is
399:
400: l_rate_type po_system_parameters.default_rate_type%TYPE;
401: l_rate number;
402: l_denominator_rate number;
403: l_numerator_rate number;
404: l_approval_currency varchar2(30);

Line 415: FROM po_system_parameters;

411:
412: begin
413: SELECT default_rate_type
414: INTO l_rate_type
415: FROM po_system_parameters;
416:
417: l_progress := 'getReqAmountInfo:' || l_rate_type;
418: IF (g_po_wf_debug = 'Y') THEN
419: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);