APPS.FII_COM_CC_DIM_MAPS_PKG dependencies on FII_COM_CC_DIM_MAPS_GT

Line 161: -- To populate those id's also in FII_COM_CC_DIM_MAPS_GT

157: ------------------------------------------------------------------------------
158: -- There is a possibility of having Company_id and cost_center_id
159: -- in FII_GL_CCID_DIMENSIONS which might not be present in the
160: -- corresponding Dimension hierarchy (it might now be mapped)
161: -- To populate those id's also in FII_COM_CC_DIM_MAPS_GT
162: -- outer join is used.
163: -- Also since both Company and Cost Center Dimension can be mapped
164: -- to either Balancing / Cost Center Segment so we need to identify
165: -- that the dimension is mapped to which segment. If the Dimension

Line 173: INSERT INTO FII_COM_CC_DIM_MAPS_GT (PARENT_COMPANY_DIM_ID,

169: -- Cost_Center_id From FII_GL_CCID_DIMENSIONS and FII_BUDGET_BASE
170: -- should be mapped to the dimension table. Decode is used for this purpose
171: --------------------------------------------------------------------------------
172:
173: INSERT INTO FII_COM_CC_DIM_MAPS_GT (PARENT_COMPANY_DIM_ID,
174: CHILD_COMPANY_ID,
175: PARENT_COST_CENTER_DIM_ID,
176: CHILD_COST_CENTER_ID)
177: SELECT

Line 247: g_phase := 'Populate FII_COM_CC_DIM_MAPS_GT';

243:
244: Initialize;
245:
246: -- Populate the com cc dim maps GT.
247: g_phase := 'Populate FII_COM_CC_DIM_MAPS_GT';
248:
249: Populate_com_cc_Maps;
250: -- Populate by selecting from the mappings table
251:

Line 278: FROM FII_COM_CC_DIM_MAPS_GT;

274: FII_USER_ID,
275: SYSDATE,
276: FII_USER_ID,
277: FII_LOGIN_ID
278: FROM FII_COM_CC_DIM_MAPS_GT;
279:
280: IF (FIIDIM_Debug) THEN
281: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows from FII_COM_CC_DIM_MAPS');
282: END IF;

Line 355: g_phase := 'Populate FII_COM_CC_DIM_MAPS_GT';

351:
352: Initialize;
353:
354: -- Populate the com cc dim maps GT table.
355: g_phase := 'Populate FII_COM_CC_DIM_MAPS_GT';
356:
357: Populate_com_cc_Maps;
358:
359: -- -----------------------------------------------------

Line 383: FROM FII_COM_CC_DIM_MAPS_GT);

379: SELECT PARENT_COMPANY_DIM_ID,
380: CHILD_COMPANY_ID,
381: PARENT_COST_CENTER_DIM_ID,
382: CHILD_COST_CENTER_ID
383: FROM FII_COM_CC_DIM_MAPS_GT);
384:
385:
386: IF (FIIDIM_Debug) THEN
387: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_COM_CC_DIM_MAPS');

Line 411: FROM FII_COM_CC_DIM_MAPS_GT

407: FII_USER_ID,
408: SYSDATE,
409: FII_USER_ID,
410: FII_LOGIN_ID
411: FROM FII_COM_CC_DIM_MAPS_GT
412: MINUS
413: SELECT
414: PARENT_COMPANY_DIM_ID,
415: CHILD_COMPANY_ID,