DBA Data[Home] [Help]

APPS.AMS_EVENTOFFER_PVT dependencies on AMS_EVENT_OFFERS_VL

Line 3256: 'ams_event_offers_vl',

3252: AND p_evo_rec.source_code IS NOT NULL
3253: THEN
3254: /*
3255: IF AMS_Utility_PVT.check_uniqueness(
3256: 'ams_event_offers_vl',
3257: 'source_code = ''' || p_evo_rec.source_code || ''''
3258: ) = FND_API.g_false
3259: */
3260: open c_src_code(p_evo_rec.source_code);

Line 4408: FROM ams_event_offers_vl

4404: )
4405: IS
4406: CURSOR c_evo IS
4407: SELECT *
4408: FROM ams_event_offers_vl
4409: WHERE event_offer_id = p_evo_rec.event_offer_id;
4410:
4411: CURSOR c_source_code IS
4412: SELECT 1

Line 5117: FROM ams_event_offers_vl

5113: IS
5114:
5115: CURSOR c_evo IS
5116: SELECT *
5117: FROM ams_event_offers_vl
5118: WHERE event_offer_id = p_evo_rec.event_offer_id;
5119:
5120: CURSOR c_location(loc_id IN NUMBER) IS
5121: SELECT city, state, country