DBA Data[Home] [Help]

APPS.FII_GL_EXTRACTION_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 131: from fii_ccc_mgr_gt gt, hr_all_organization_units ou

127: -- date_to null is also considered because the organizations having null
128: -- to date will not be considered as inactive.
129: cursor missing_csr is
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);