122: and hoi.organization_id = gt.ccc_org_id;
123:
124: BEGIN
125: -- Populate FII_CCC_MGR_GT
126: FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR (p_status);
127:
128: IF p_status = -1 then
129: fii_util.write_log('Error in FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR ...');
130: fii_util.write_log('Table FII_CCC_MGR_GT is not populated');
125: -- Populate FII_CCC_MGR_GT
126: FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR (p_status);
127:
128: IF p_status = -1 then
129: fii_util.write_log('Error in FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR ...');
130: fii_util.write_log('Table FII_CCC_MGR_GT is not populated');
131: raise NO_DATA_FOUND;
132: END IF;
133: