APPS.PO_CREATE_ISO dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 113: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;

109: --BUG10037733 variable definitions.
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);

Line 542: financials_system_parameters fsp,

538: --get the currency_code functional currency from gl
539: select currency_code
540: into l_dest_currency_code
541: from
542: financials_system_parameters fsp,
543: gl_sets_of_books gl
544: where gl.set_of_books_id = fsp.set_of_books_id
545: --#bug 12816938 add org condition to return single row for multi org.
546: and fsp.org_id = l_org_id;

Line 613: FROM financials_system_parameters

609: -- interface after converting to the source org currency
610: --convert price into source org currency
611: SELECT set_of_books_id
612: INTO l_sob_id
613: FROM financials_system_parameters
614: --#bug 12816938 add org condition to return single row for multi org.
615: WHERE org_id = l_org_id;
616:
617: SELECT default_rate_type