1122: l_ARC_ACT_CATEGORY_USED_BY := NULL;
1123: l_rec_cnt := 0;
1124:
1125: select count(*) into l_rec_cnt
1126: FROM ams_act_categories
1127: where ACT_CATEGORY_USED_BY_ID = l_event_offer_id;
1128:
1129: IF (l_rec_cnt > 0) THEN
1130:
1129: IF (l_rec_cnt > 0) THEN
1130:
1131: SELECT ARC_ACT_CATEGORY_USED_BY
1132: INTO l_ARC_ACT_CATEGORY_USED_BY
1133: FROM ams_act_categories
1134: where ACT_CATEGORY_USED_BY_ID = l_event_offer_id;
1135:
1136: END IF;
1137: