APPS.FII_CC_MGR_SUP_C dependencies on FII_PERSON_ID_TMP

Line 145: --Insert these records into global temporary table FII_PERSON_ID_TMP

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:
147: g_phase := 'Insert into table FII_PERSON_ID_TMP';
148:
149: INSERT into FII_PERSON_ID_TMP (person_id)

Line 147: g_phase := 'Insert into table FII_PERSON_ID_TMP';

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:
147: g_phase := 'Insert into table FII_PERSON_ID_TMP';
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

Line 149: INSERT into FII_PERSON_ID_TMP (person_id)

145: --Insert these records into global temporary table FII_PERSON_ID_TMP
146:
147: g_phase := 'Insert into table FII_PERSON_ID_TMP';
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,

Line 162: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_PERSON_ID_TMP');

158: and suph.sup_assignment_status_type_id = ast.assignment_status_type_id
159: and ast.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
160:
161: if g_debug_flag = 'Y' then
162: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_PERSON_ID_TMP');
163: end if;
164:
165: ----------------------------------------------------------
166: --Begin to populate the table FII_CC_MGR_HIER_GT

Line 211: and sub.sub_person_id in (select person_id from FII_PERSON_ID_TMP);

207: and sub.sup_invalid_flag_code = 'N'
208: and sub.sub_invalid_flag_code = 'N'
209: and sub.sub_primary_asg_flag_code = 'Y'
210: and sysdate between sub.effective_start_date and sub.effective_end_date
211: and sub.sub_person_id in (select person_id from FII_PERSON_ID_TMP);
212:
213: ---------------------------------------------------------------
214:
215: if g_debug_flag = 'Y' then