793:
794: if p_parent_bill_seq_id is null then
795: select concatenated_segments
796: into l_item_catalog_grp_name
797: from MTL_ITEM_CATALOG_GROUPS_B_KFV
798: where item_catalog_group_id = p_item_catalog_grp_id;
799: else
800: select pk1_value
801: into l_item_catalog_grp_id
804: and obj_name= 'EGO_CATALOG_GROUP';
805:
806: select concatenated_segments
807: into l_item_catalog_grp_name
808: from MTL_ITEM_CATALOG_GROUPS_B_KFV
809: where item_catalog_group_id = l_item_catalog_grp_id;
810: end if;
811:
812: return l_item_catalog_grp_name;