DBA Data[Home] [Help]

APPS.AMS_EVENTSCHEDULE_COPY_PVT dependencies on AMS_ACT_CATEGORIES

Line 1126: FROM ams_act_categories

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:

Line 1133: FROM ams_act_categories

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: