APPS.AMS_EVENTOFFER_PVT dependencies on AMS_SOURCE_CODES

Line 1048: -- Source Code in ams_source_codes table.

1044: END IF;
1045:
1046: --
1047: -- The AMS_SourceCode_PVT takes care of inserting the newly generated
1048: -- Source Code in ams_source_codes table.
1049: --
1050: --
1051: --
1052: -- sugupta 22-May-2000

Line 3223: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_source_codes

3219: IS
3220: l_valid_flag VARCHAR2(1);
3221: l_dummy NUMBER;
3222: cursor c_src_code(src_code_in IN VARCHAR2) IS
3223: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_source_codes
3224: where SOURCE_CODE = src_code_in);
3225: BEGIN
3226: x_return_status := FND_API.g_ret_sts_success;
3227:

Line 4413: FROM ams_source_codes

4409: WHERE event_offer_id = p_evo_rec.event_offer_id;
4410:
4411: CURSOR c_source_code IS
4412: SELECT 1
4413: FROM ams_source_codes
4414: WHERE source_code = p_evo_rec.source_code
4415: AND active_flag = 'Y';
4416:
4417: l_track_id NUMBER;