APPS.FII_CC_MGR_SUP_C dependencies on FII_CCC_MGR_GT

Line 132: g_phase := 'Populate table FII_CCC_MGR_GT to replace HRI_CS_PER_ORGCC_CT';

128: -- Initialize setups
129: ------------------------------------------------
130: INIT;
131:
132: g_phase := 'Populate table FII_CCC_MGR_GT to replace HRI_CS_PER_ORGCC_CT';
133:
134: FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR (l_status);
135:
136: IF l_status = -1 then

Line 138: FII_UTIL.put_line('Table FII_CCC_MGR_GT is not populated');

134: FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR (l_status);
135:
136: IF l_status = -1 then
137: FII_UTIL.put_line('Error in FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR ...');
138: FII_UTIL.put_line('Table FII_CCC_MGR_GT is not populated');
139: raise NO_DATA_FOUND;
140: END IF;
141:
142: --First, join the fii_ccc_mgr_gt table with hri_cs_suph to

Line 142: --First, join the fii_ccc_mgr_gt table with hri_cs_suph to

138: FII_UTIL.put_line('Table FII_CCC_MGR_GT is not populated');
139: raise NO_DATA_FOUND;
140: END IF;
141:
142: --First, join the fii_ccc_mgr_gt table with hri_cs_suph to
143: --get a distinct list of managers who have cost center responsibility
144: --(i.e. own a cost center or have a subordinate who does).
145: --Insert these records into global temporary table FII_PERSON_ID_TMP
146:

Line 152: from fii_ccc_mgr_gt ct,

148:
149: INSERT into FII_PERSON_ID_TMP (person_id)
150: select /*+ leading(ct) full(ct) index(suph HRI_CS_SUPH_N4) use_nl(ct suph) */
151: distinct suph.sup_person_id
152: from fii_ccc_mgr_gt ct,
153: hri_cs_suph suph,
154: per_assignment_status_types ast
155: where ct.manager = suph.sub_person_id
156: and sysdate between suph.effective_start_date