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 1104: financials_system_params_all FSP, gl_sets_of_books SOB

1100: CURSOR cur_get_curr_code IS
1101: SELECT
1102: sob.currency_code
1103: FROM
1104: financials_system_params_all FSP, gl_sets_of_books SOB
1105: WHERE
1106: FSP.set_of_books_id = SOB.set_of_books_id
1107: AND FSP.org_id = v_operating_id ;
1108: