DBA Data[Home] [Help]

APPS.PO_CORE_S2 dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 31: FROM FINANCIALS_SYSTEM_PARAMETERS FSP,

27: --bug#5092574 Use the doc_org_id to join with FSP to retrieve the
28: --Req Currency
29: SELECT GSB.currency_code
30: INTO x_base_currency
31: FROM FINANCIALS_SYSTEM_PARAMETERS FSP,
32: GL_SETS_OF_BOOKS GSB
33: WHERE FSP.set_of_books_id = GSB.set_of_books_id
34: AND FSP.ORG_ID=p_org_id;
35:

Line 144: FROM FINANCIALS_SYSTEM_PARAMETERS FSP,

140: BEGIN
141:
142: SELECT GSB.currency_code
143: INTO x_currency_code
144: FROM FINANCIALS_SYSTEM_PARAMETERS FSP,
145: GL_SETS_OF_BOOKS GSB
146: WHERE FSP.set_of_books_id = GSB.set_of_books_id;
147:
148: return(x_currency_code);