APPS.INV_EGO_REVISION_VALIDATE dependencies on EGO_CAT_GRP_TEMPLATES

Line 2217: FROM EGO_CAT_GRP_TEMPLATES cat_temp,

2213: RETURN NUMBER IS
2214:
2215: CURSOR C_Default_Template(cp_catalog_group_id NUMBER) IS
2216: SELECT cat_temp.TEMPLATE_ID
2217: FROM EGO_CAT_GRP_TEMPLATES cat_temp,
2218: MTL_ITEM_TEMPLATES temp
2219: WHERE cat_temp.CATALOG_GROUP_ID = cp_catalog_group_id
2220: AND cat_temp.DEFAULT_FLAG = 'Y'
2221: AND cat_temp.TEMPLATE_ID = temp.TEMPLATE_ID;

Line 2738: WHERE EXISTS(SELECT 1 FROM ego_cat_grp_templates

2734: IF (INV_ITEM_UTIL.APPL_INST_EGO <> 0) THEN
2735: EXECUTE IMMEDIATE
2736: 'SELECT count(*)
2737: FROM dual
2738: WHERE EXISTS(SELECT 1 FROM ego_cat_grp_templates
2739: WHERE template_id = :p_template_id)'
2740: INTO l_template_exists
2741: USING p_template_id;
2742: END IF;