APPS.PER_ASSIGNMENTS_F2_PKG dependencies on FINANCIALS_SYSTEM_PARAMETERS

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

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

Line 322: from financials_system_parameters

318: -- Bug 874343 Query set_of_books id from financial_system_params_all
319: --
320: cursor sob_id is
321: select set_of_books_id
322: from financials_system_parameters
323: where business_group_id = p_bus_grp_id;
324: --
325: cursor get_gl_info is
326: select chart_of_accounts_id, name

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

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

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

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

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

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

Line 346: -- 'FINANCIALS_SYSTEM_PARAMETERS')

342: --cursor fsp_table_name is
343: -- select table_name
344: -- from user_catalog
345: -- where table_name in ('FINANCIALS_SYSTEM_PARAMS_ALL',
346: -- 'FINANCIALS_SYSTEM_PARAMETERS')
347: -- order by table_name desc;
348: --
349: cursor scl is
350: select rule_mode