DBA Data[Home] [Help]

APPS.PO_PRICE_BREAK_GRP dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 387: FINANCIALS_SYSTEM_PARAMETERS FSP,

383: /* Bug 2842675 Get the base currency extended precision */
384: SELECT nvl(FND.extended_precision,5)
385: INTO l_base_curr_ext_precision
386: FROM FND_CURRENCIES FND,
387: FINANCIALS_SYSTEM_PARAMETERS FSP,
388: GL_SETS_OF_BOOKS GSB
389: WHERE FSP.set_of_books_id = GSB.set_of_books_id AND
390: FND.currency_code = GSB.currency_code;
391:

Line 1079: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;

1075: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1076: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1077: l_po_rate PO_HEADERS_ALL.rate%TYPE;
1078:
1079: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
1080: l_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE;
1081:
1082: x_rate PO_HEADERS_ALL.rate%TYPE;
1083:

Line 1108: FROM financials_system_parameters;

1104: ELSE
1105:
1106: SELECT set_of_books_id
1107: INTO l_sob_id
1108: FROM financials_system_parameters;
1109:
1110: SELECT default_rate_type
1111: INTO l_rate_type
1112: FROM po_system_parameters;