DBA Data[Home] [Help]

APPS.BIM_EVENT_FACTS dependencies on BIM_INTL_DATES

Line 694: bim_intl_dates DAT

690: trunc(dat.trdate) tr_date
691: FROM
692: ams_event_headers_all_b a,
693: ams_source_codes E,
694: bim_intl_dates DAT
695: WHERE dat.trdate between a.active_from_date and
696: decode(greatest(a.active_to_date,p_end_datel),a.active_to_date,p_end_datel,NULL,p_end_datel,a.active_to_date) + 0.99999
697: AND a.active_from_date+0 >= p_start_datel
698: AND a.active_from_date+0 <= p_end_datel

Line 1030: bim_intl_dates DAT

1026: trunc(dat.trdate) tr_date
1027: FROM ams_event_offers_all_b A,
1028: ams_event_headers_all_b B,
1029: ams_source_codes E,
1030: bim_intl_dates DAT
1031: WHERE dat.trdate between a.event_start_date and
1032: decode(greatest(a.event_end_date,p_end_datel),a.event_end_date,p_end_datel,NULL,p_end_datel,a.event_end_date) + 0.99999
1033: AND a.event_start_date+0 >= p_start_datel
1034: AND a.event_start_date+0 <= p_end_datel