APPS.OZF_ACT_OFFERS_PVT dependencies on AMS_CAMPAIGNS_VL

Line 1124: 'AMS_CAMPAIGNS_VL',

1120: THEN
1121: IF p_act_offer_rec.arc_act_offer_used_by = 'CAMP' THEN
1122: l_fk_flag := OZF_Utility_PVT.check_fk_exists
1123: (
1124: 'AMS_CAMPAIGNS_VL',
1125: 'campaign_id',
1126: p_act_offer_rec.act_offer_used_by_id
1127: );
1128: ELSE

Line 1370: SELECT count(*) FROM AMS_CAMPAIGNS_VL

1366: )
1367: IS
1368:
1369: CURSOR c_active(used_by_id IN NUMBER) IS
1370: SELECT count(*) FROM AMS_CAMPAIGNS_VL
1371: WHERE campaign_id = used_by_id
1372: AND (actual_exec_end_date IS NULL
1373: -- changed by rssharma for bug fixing on 01/26/2001
1374: OR actual_exec_end_date >= trunc(SYSDATE) );