DBA Data[Home] [Help]

APPS.FII_GL_EXTRACTION_UTIL dependencies on FND_PROFILE

Line 5: nvl( fnd_profile.value( 'FII_DEBUG_MODE' ), 'N' );

1: PACKAGE BODY FII_GL_EXTRACTION_UTIL AS
2: /* $Header: FIIGLXUB.pls 120.3 2005/08/16 14:19:19 arcdixit noship $ */
3:
4: g_debug_flag varchar2(1) :=
5: nvl( fnd_profile.value( 'FII_DEBUG_MODE' ), 'N' );
6: g_state varchar2(200) := null;
7: g_errbuf varchar2(2000) := null;
8: g_retcode varchar2(200) := null;
9: g_exception_msg varchar2(4000) := null;

Line 134: and (to_date(to_char(date_to,'mm/dd/yyyy'),'mm/dd/yyyy') >= to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'mm/dd/yyyy')

130: select distinct ou.name
131: from fii_ccc_mgr_gt gt, hr_all_organization_units ou
132: where gt.manager is null
133: and gt.ccc_org_id = ou.organization_id
134: and (to_date(to_char(date_to,'mm/dd/yyyy'),'mm/dd/yyyy') >= to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'mm/dd/yyyy')
135: or date_to is null);
136:
137: l_count number :=0;
138: