APPS.PER_ASSIGNMENTS_F2_PKG dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 311: -- from the financials_system_parameters table, rather than from a

307: where application_id = 200
308: and status = 'I';
309: --
310: -- #345809 Added a cursor to get the set_of_books_id
311: -- from the financials_system_parameters table, rather than from a
312: -- client-side profile. See bug 243960 for more details.
313: --
314: -- Bug 874343 Query set_of_books id from financial_system_params_all
315: --

Line 318: from financials_system_parameters

314: -- Bug 874343 Query set_of_books id from financial_system_params_all
315: --
316: cursor sob_id is
317: select set_of_books_id
318: from financials_system_parameters
319: where business_group_id = p_bus_grp_id;
320: --
321: cursor get_gl_info is
322: select chart_of_accounts_id, name

Line 326: -- #345809 Now find out which of the financials_system_parameters tables

322: select chart_of_accounts_id, name
323: from gl_sets_of_books
324: where set_of_books_id = p_gl_set_of_books_id;
325: --
326: -- #345809 Now find out which of the financials_system_parameters tables
327: -- is available, if any. Options are:
328: --
329: -- FINANCIALS_SYSTEM_PARAMS_ALL (10.6 install)
330: -- FINANCIALS_SYSTEM_PARAMETERS (10.5 HR + other apps install)

Line 330: -- FINANCIALS_SYSTEM_PARAMETERS (10.5 HR + other apps install)

326: -- #345809 Now find out which of the financials_system_parameters tables
327: -- is available, if any. Options are:
328: --
329: -- FINANCIALS_SYSTEM_PARAMS_ALL (10.6 install)
330: -- FINANCIALS_SYSTEM_PARAMETERS (10.5 HR + other apps install)
331: -- none (10.5 HR only install)
332: --
333: -- The ORDER BY clause ensures we pick up FINANCIALS_SYSTEM_PARAMS_ALL
334: -- if it's there, ahead of FINANCIALS_SYSTEM_PARAMETERS.

Line 334: -- if it's there, ahead of FINANCIALS_SYSTEM_PARAMETERS.

330: -- FINANCIALS_SYSTEM_PARAMETERS (10.5 HR + other apps install)
331: -- none (10.5 HR only install)
332: --
333: -- The ORDER BY clause ensures we pick up FINANCIALS_SYSTEM_PARAMS_ALL
334: -- if it's there, ahead of FINANCIALS_SYSTEM_PARAMETERS.
335: --
336: -- Bug 874343 - No longer need to query for financial system params tables.
337: --
338: --cursor fsp_table_name is

Line 342: -- 'FINANCIALS_SYSTEM_PARAMETERS')

338: --cursor fsp_table_name is
339: -- select table_name
340: -- from user_catalog
341: -- where table_name in ('FINANCIALS_SYSTEM_PARAMS_ALL',
342: -- 'FINANCIALS_SYSTEM_PARAMETERS')
343: -- order by table_name desc;
344: --
345: cursor scl is
346: select rule_mode