APPS.AMS_ASSOCIATIONS_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 77: FROM AMS_CAMPAIGN_SCHEDULES_B

73: WHERE object_association_id = association_id;
74:
75: CURSOR c_get_lang_code ( l_camp_sch_id IN NUMBER) IS
76: SELECT language_code
77: FROM AMS_CAMPAIGN_SCHEDULES_B
78: WHERE schedule_id = l_camp_sch_id;
79:
80: CURSOR c_get_delv_details(l_delv_id IN NUMBER) IS
81: SELECT actual_avail_from_date,actual_avail_to_date,language_code

Line 1190: THEN l_foreign_table := 'AMS_CAMPAIGN_SCHEDULES_B';

1186: ELSIF p_master_type = 'CAMP'
1187: THEN l_foreign_table := 'AMS_CAMPAIGNS_ALL_B';
1188: l_foreign_table_id := 'CAMPAIGN_ID';
1189: ELSIF p_master_type = 'CSCH'
1190: THEN l_foreign_table := 'AMS_CAMPAIGN_SCHEDULES_B';
1191: l_foreign_table_id := 'SCHEDULE_ID';
1192: ELSE
1193:
1194: return FND_API.g_false;

Line 1644: FROM ams_campaign_schedules_b

1640:
1641: CURSOR c_csch_end_date(l_camp_sche_id IN NUMBER)
1642: IS
1643: SELECT end_date_time
1644: FROM ams_campaign_schedules_b
1645: WHERE schedule_id = l_camp_sche_id;
1646:
1647: l_end_date date ;
1648: