APPS.AMS_EVENTOFFER_PVT dependencies on AMS_CAMPAIGNS_ALL_B

Line 3400: 'AMS_CAMPAIGNS_ALL_B',

3396: END IF;
3397: ----------------------- parent_id ------------------------
3398: IF p_evo_rec.parent_id <> FND_API.g_miss_num THEN
3399: IF AMS_Utility_PVT.check_fk_exists(
3400: 'AMS_CAMPAIGNS_ALL_B',
3401: 'CAMPAIGN_ID',
3402: p_evo_rec.parent_id
3403: ) = FND_API.g_false
3404: THEN

Line 4189: from AMS_CAMPAIGNS_ALL_B

4185: l_parent_end_date DATE;
4186:
4187: cursor get_parent_date (id_in in NUMBER)is
4188: select ACTUAL_EXEC_START_DATE, ACTUAL_EXEC_END_DATE
4189: from AMS_CAMPAIGNS_ALL_B
4190: where CAMPAIGN_ID = id_in
4191: and ROLLUP_TYPE = 'RCAM';
4192:
4193: BEGIN

Line 7000: FROM ams_campaigns_all_b

6996:
6997: CURSOR c_program IS
6998: -- SELECT actual_exec_start_date , actual_exec_end_date FROM ams_campaigns_v
6999: SELECT actual_exec_start_date , actual_exec_end_date
7000: FROM ams_campaigns_all_b
7001: WHERE campaign_id = p_evo_rec.parent_id;
7002:
7003: CURSOR c_event IS
7004: -- SELECT active_from_date, active_to_date FROM ams_event_headers_v

Line 7129: FROM ams_campaigns_all_b

7125:
7126: CURSOR c_program IS
7127: -- SELECT status_code FROM ams_campaigns_v
7128: SELECT status_code
7129: FROM ams_campaigns_all_b
7130: WHERE campaign_id = p_evo_rec.parent_id;
7131:
7132: CURSOR c_event IS
7133: -- SELECT system_status_code FROM ams_event_headers_v