APPS.PN_MO_CACHE_UTILS dependencies on PN_SYSTEM_SETUP_OPTIONS

Line 254: pn_system_setup_options pn

250: p_globals.smallest_term_amount_t,
251: p_globals.incl_terms_by_default_flag_t
252: FROM hr_legal_entities hr,
253: gl_sets_of_books gl,
254: pn_system_setup_options pn
255: WHERE pn_mo_cache_utils.check_access(pn.org_id) = 'Y'
256: AND gl.set_of_books_id = pn.set_of_books_id
257: AND hr.organization_id (+) = pn.org_id;
258:

Line 337: pn_system_setup_options pn

333: p_globals.recalc_ir_on_acc_chg_flag_t,
334: p_globals.smallest_term_amount_t, --#@#Bug4291907
335: p_globals.incl_terms_by_default_flag_t
336: FROM gl_sets_of_books gl,
337: pn_system_setup_options pn
338: WHERE gl.set_of_books_id = pn.set_of_books_id;
339:
340: END IF;
341: EXCEPTION

Line 360: -- pn_system_setup_options table

356: -- a specific OU
357: -- NOTE o This procedure is an addendum (not defined in the template)
358: -- o For non multi org cases
359: -- oo assumed that only 1 row exists in the
360: -- pn_system_setup_options table
361: --
362: -- INVOKED FROM :
363: -- ARGUMENTS : IN p_org_id
364: -- OUT p_table

Line 432: pn_system_setup_options pn

428: pn.smallest_term_amount smallest_term_amount,
429: pn.incl_terms_by_default_flag incl_terms_by_default_flag
430: FROM hr_legal_entities hr,
431: gl_sets_of_books gl,
432: pn_system_setup_options pn
433: WHERE mo_global.check_access(pn.org_id) = 'Y'
434: AND gl.set_of_books_id = pn.set_of_books_id
435: AND hr.organization_id (+) = pn.org_id
436: AND nvl(pn.org_id,l_dummy_org_id) = p_id;

Line 507: -- pn_system_setup_options table (until MO is activated)

503: -------------------------------------------------------------------------------
504: -- FUNCTION : get_profile_value
505: -- PURPOSE : wrapper function for fnd_profile.value() due to MO
506: -- NOTE : temporarily assume either 1 or 0 entry for
507: -- pn_system_setup_options table (until MO is activated)
508: -- INVOKED FROM : get_profile_value in PNCOMMON.pld and *.pls files.
509: -- ARGUMENTS : IN p_profile_name, p_org_id
510: -- OUT NONE
511: -- RETURNS : the profile value for a profile name for an operating unit

Line 575: FROM pn_system_setup_options

571: allow_tenancy_overlap_flag,
572: recalc_ir_on_acc_chg_flag,
573: smallest_term_amount,
574: incl_terms_by_default_flag
575: FROM pn_system_setup_options
576: WHERE org_id = nvl(p_org_id, fnd_profile.value('ORG_ID'));
577:
578: BEGIN
579: