APPS.BIM_CAMP_COLLECTION dependencies on BIM_REP_HISTORY

Line 44: FROM bim_rep_history

40: BEGIN
41: EXECUTE IMMEDIATE 'TRUNCATE TABLE bim_dates';
42: SELECT MIN(start_date)
43: INTO l_min_start_date
44: FROM bim_rep_history
45: WHERE OBJECT = 'CAMPAIGN';
46: FOR x IN c_month(l_min_start_date)
47: LOOP
48: --BEGIN

Line 272: FROM bim_rep_history

268: sysdate_1 date := TRUNC(SYSDATE- 1);
269: CURSOR chk_history_data
270: IS
271: SELECT MIN(start_date)
272: FROM bim_rep_history
273: WHERE OBJECT = 'CAMPAIGN';
274: BEGIN
275: OPEN chk_history_data;
276: FETCH chk_history_data INTO l_min_start_date;

Line 2872: FROM bim_rep_history

2868: sysdate_1 date := TRUNC(SYSDATE- 1);
2869: CURSOR chk_history_data
2870: IS
2871: SELECT MIN(start_date)
2872: FROM bim_rep_history
2873: WHERE OBJECT = 'CAMPAIGN';
2874: BEGIN
2875: OPEN chk_history_data;
2876: FETCH chk_history_data INTO l_min_start_date;