APPS.BIM_SOURCE_CODE_PKG dependencies on AMS_SOURCE_CODES

Line 219: ams_source_codes a,

215: c.country_code country_code,
216: b.actual_exec_start_date start_date,
217: b.actual_exec_end_date end_date
218: FROM
219: ams_source_codes a,
220: ams_campaigns_all_b b,
221: jtf_loc_hierarchies_b c
222: WHERE
223: a.source_code = b.source_code

Line 242: ams_source_codes a,

238: d.country_code country_code,
239: c.start_date_time start_date,
240: c.end_date_time end_date
241: FROM
242: ams_source_codes a,
243: ams_campaigns_all_b b,
244: ams_campaign_schedules_b c,
245: jtf_loc_hierarchies_b d
246: WHERE

Line 267: ams_source_codes a,

263: c.country_code country_code,
264: b.active_from_date start_date,
265: b.active_to_date end_date
266: FROM
267: ams_source_codes a,
268: ams_event_headers_all_b b,
269: jtf_loc_hierarchies_b c
270: WHERE
271: a.source_code = b.source_code

Line 290: ams_source_codes a,

286: d.country_code country_code,
287: c.event_start_date start_date,
288: c.event_end_date end_date
289: FROM
290: ams_source_codes a,
291: ams_event_headers_all_b b,
292: ams_event_offers_all_b c,
293: jtf_loc_hierarchies_b d
294: WHERE