APPS.FII_PMV_HELPER_TABLES_C dependencies on FII_FINANCIAL_DIMENSIONS

Line 163: FROM FII_FINANCIAL_DIMENSIONS

159:
160: BEGIN
161: SELECT DBI_ENABLED_FLAG, DBI_HIER_TOP_NODE_ID
162: INTO G_FC_DBI_ENABLED_FLAG, G_FC_TOP_NODE_ID
163: FROM FII_FINANCIAL_DIMENSIONS
164: WHERE DIMENSION_SHORT_NAME = 'GL_FII_FIN_ITEM';
165:
166: IF(G_FC_DBI_ENABLED_FLAG = 'Y' and G_FC_TOP_NODE_ID is NULL) THEN
167: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',

Line 198: FROM FII_FINANCIAL_DIMENSIONS

194: -- Get the enabled flag for Company
195: BEGIN
196: SELECT DBI_ENABLED_FLAG, DBI_HIER_TOP_NODE_ID
197: INTO G_CO_DBI_ENABLED_FLAG, G_CO_TOP_NODE_ID
198: FROM FII_FINANCIAL_DIMENSIONS
199: WHERE DIMENSION_SHORT_NAME = 'FII_COMPANIES';
200:
201: IF(G_CO_DBI_ENABLED_FLAG = 'Y' and G_CO_TOP_NODE_ID is NULL) THEN
202: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',

Line 237: FROM FII_FINANCIAL_DIMENSIONS

233: -- Get the enabled flag for CC
234: BEGIN
235: SELECT DBI_ENABLED_FLAG, DBI_HIER_TOP_NODE_ID
236: INTO G_CC_DBI_ENABLED_FLAG, G_CC_TOP_NODE_ID
237: FROM FII_FINANCIAL_DIMENSIONS
238: WHERE DIMENSION_SHORT_NAME = 'HRI_CL_ORGCC';
239:
240: IF(G_CC_DBI_ENABLED_FLAG = 'Y' and G_CC_TOP_NODE_ID is NULL) THEN
241: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',

Line 277: FROM FII_FINANCIAL_DIMENSIONS

273:
274: BEGIN
275: SELECT DBI_ENABLED_FLAG, DBI_HIER_TOP_NODE_ID
276: INTO G_UDD1_DBI_ENABLED_FLAG, G_UDD1_TOP_NODE_ID
277: FROM FII_FINANCIAL_DIMENSIONS
278: WHERE DIMENSION_SHORT_NAME = 'FII_USER_DEFINED_1';
279:
280: IF(G_UDD1_DBI_ENABLED_FLAG = 'Y' and G_UDD1_TOP_NODE_ID is NULL) THEN
281: FII_MESSAGE.write_log (msg_name => 'FII_TNODE_NOT_FOUND',