eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_CC_MGR_SUP_C dependencies on HRI_CS_SUPH

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 150: select /+ leading(ct) full(ct) index(suph HRI_CS_SUPH_N4) use_nl(ct suph) /

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,
154: per_assignment_status_types ast

Line 153: hri_cs_suph suph,

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
157: and suph.effective_end_date

Line 198: from hri_cs_suph sup,

194: sub.sub_level emp_level,
195: 'N' next_level_is_leaf,
196: 'N' is_leaf_flag,
197: decode(SIGN(sub.sub_level-G_AGGREGATION_LEVELS),1,'N','Y') aggregation_flag
198: from hri_cs_suph sup,
199: hri_cs_suph sub
200: where sup.sub_relative_level <= 1
201: and (sup.sub_relative_level = 1 OR sup.sup_level = 1)
202: and sup.sup_invalid_flag_code = 'N'

Line 199: hri_cs_suph sub