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 117: FROM FINANCIALS_SYSTEM_PARAMETERS FSP,

113: BEGIN
114:
115: SELECT GSB.currency_code
116: INTO x_currency_code
117: FROM FINANCIALS_SYSTEM_PARAMETERS FSP,
118: GL_SETS_OF_BOOKS GSB
119: WHERE FSP.set_of_books_id = GSB.set_of_books_id;
120:
121: return(x_currency_code);