APPS.PO_CREATE_ISO dependencies on PO_SYSTEM_PARAMETERS

Line 114: l_conversion_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE;

110: l_unit_list_price number;
111: l_unit_selling_price number;
112: l_conversion_date PO_REQ_DISTRIBUTIONS.gl_encumbered_date%TYPE;
113: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
114: l_conversion_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE;
115: l_rate NUMBER;
116: l_source_currency_code VARCHAR2(15);
117: l_dest_currency_code VARCHAR2(15);
118: --BUG10037733

Line 619: FROM po_system_parameters

615: WHERE org_id = l_org_id;
616:
617: SELECT default_rate_type
618: INTO l_conversion_type
619: FROM po_system_parameters
620: --#bug 12816938 add org condition to return single row for multi org.
621: WHERE org_id = l_org_id;
622:
623: --the conversion date is sysdate

Line 853: FROM PO_SYSTEM_PARAMETERS_ALL

849: Fnd_File.Put_Line(FND_FILE.LOG, 'Selecting Order Type');
850:
851: SELECT ORDER_TYPE_ID
852: INTO l_ot_id
853: FROM PO_SYSTEM_PARAMETERS_ALL
854: WHERE nvl(ORG_ID,-1) = l_op_unit_id;
855:
856: EXCEPTION
857: WHEN NO_DATA_FOUND THEN