DBA Data[Home] [Help]

APPS.JAI_PO_LLA_TRIGGER_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 11: FINANCIALS_SYSTEM_PARAMS_ALL along with GL_SETS_OF_BOOKS talbe to get the

7: 1. Ramananada for bug#4703617. File Version 120.1
8: To get the currency code from GL_SETS_OF_BOOKS table,
9: ORG_ORGANIZATION_DEFINITIONS table is referred to get the Set_Of_Books_Id.
10: But using this table has a performance impact. Hence using the table
11: FINANCIALS_SYSTEM_PARAMS_ALL along with GL_SETS_OF_BOOKS talbe to get the
12: currency code.
13: Removed the references of ORG_ORGANIZATION_DEFINITIONS and instead used
14: FINANCIALS_SYSTEM_PARAMS_ALL table
15:

Line 14: FINANCIALS_SYSTEM_PARAMS_ALL table

10: But using this table has a performance impact. Hence using the table
11: FINANCIALS_SYSTEM_PARAMS_ALL along with GL_SETS_OF_BOOKS talbe to get the
12: currency code.
13: Removed the references of ORG_ORGANIZATION_DEFINITIONS and instead used
14: FINANCIALS_SYSTEM_PARAMS_ALL table
15:
16: ********************************************************************************/
17:
18: /*

Line 953: financials_system_params_all FSP, gl_sets_of_books SOB

949: CURSOR cur_get_curr_code IS
950: SELECT
951: sob.currency_code
952: FROM
953: financials_system_params_all FSP, gl_sets_of_books SOB
954: WHERE
955: FSP.set_of_books_id = SOB.set_of_books_id
956: AND FSP.org_id = v_operating_id ;
957: