DBA Data[Home] [Help]

APPS.FII_GL_UTIL_PKG dependencies on FII_FIN_CAT_TYPE_ASSGNS

Line 1068: FROM fii_fin_cat_type_assgns a, fii_fin_item_hierarchies b

1064: type2 VARCHAR2(10);
1065: type3 VARCHAR2(10);
1066: CURSOR get_top_nodes(type1 VARCHAR2, type2 VARCHAR2, type3 VARCHAR2) IS
1067: SELECT a.fin_category_id fin_category_id, b.PARENT_FIN_CAT_ID parent_fin_cat_id
1068: FROM fii_fin_cat_type_assgns a, fii_fin_item_hierarchies b
1069: WHERE a.FIN_CAT_TYPE_CODE IN (type1, type2, type3)
1070: AND a.TOP_NODE_FLAG = 'Y'
1071: AND a.fin_category_id = b.CHILD_FIN_CAT_ID
1072: AND a.fin_category_id <> b.PARENT_FIN_CAT_ID;

Line 1203: FROM fii_fin_cat_type_assgns a, fii_fin_item_hierarchies b

1199: l_first BOOLEAN := TRUE;
1200: type1 VARCHAR2(10);
1201: CURSOR get_top_nodes(type1 VARCHAR2) IS
1202: SELECT a.fin_category_id fin_category_id, b.PARENT_FIN_CAT_ID parent_fin_cat_id
1203: FROM fii_fin_cat_type_assgns a, fii_fin_item_hierarchies b
1204: WHERE a.FIN_CAT_TYPE_CODE = type1
1205: AND a.TOP_NODE_FLAG = 'Y'
1206: AND a.fin_category_id = b.CHILD_FIN_CAT_ID;
1207: