APPS.EGO_ITEM_CATALOG_PVT dependencies on EGO_MTL_CATALOG_GRP_VERS_B

Line 18: FROM ego_mtl_catalog_grp_vers_b ver

14: CURSOR c IS
15: SELECT 1
16: FROM dual
17: WHERE EXISTS (SELECT NULL
18: FROM ego_mtl_catalog_grp_vers_b ver
19: WHERE ver.item_catalog_group_id = p_catalog_group_id
20: AND version_seq_id > 0);
21: l_temp NUMBER(10);
22: BEGIN

Line 152: SELECT Count(*) INTO version_count FROM EGO_MTL_CATALOG_GRP_VERS_B

148: /*
149: -- CHECHAND - changes for pim for telco - bug # 8471604 - START
150:
151: if profile_value = 'Y' AND EGO_Globals.G_Catalog_Group_Rec.transaction_type = Ego_Globals.G_OPR_UPDATE THEN
152: SELECT Count(*) INTO version_count FROM EGO_MTL_CATALOG_GRP_VERS_B
153: WHERE
154: item_catalog_group_id = (SELECT item_catalog_group_id FROM mtl_item_catalog_groups_b WHERE segment1=EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name)
155: AND version_seq_id>0;
156: --dbms_output.put_line('Processing catalog group id: '||EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name ||' version count: ' || version_count);