APPS.BIM_FUND_FACTS dependencies on BIM_INTL_DATES

Line 1126: bim_intl_dates d

1122: -- decode(trunc(d.trdate),trunc(a.PROGRAM_UPDATE_DATE),a.original_budget,0) original_budget,
1123: a.original_budget original_budget,
1124: trunc(d.trdate) tr_date
1125: FROM ozf_funds_all_b a,
1126: bim_intl_dates d
1127: WHERE a.status_code in ('ACTIVE', 'CANCELLED', 'CLOSED')
1128: AND d.trdate between a.start_date_active and least(nvl(a.end_date_active,sysdate-1),p_end_datel)
1129: AND a.start_date_active between p_start_datel and p_end_datel
1130: GROUP BY a.fund_id,

Line 1227: bim_intl_dates d

1223: -- decode(trunc(d.trdate),trunc(a.PROGRAM_UPDATE_DATE),a.original_budget,0) original_budget,
1224: a.original_budget original_budget,
1225: trunc(d.trdate) tr_date
1226: FROM ozf_funds_all_b a,
1227: bim_intl_dates d
1228: WHERE a.status_code in ('ACTIVE', 'CANCELLED', 'CLOSED')
1229: AND d.trdate between a.start_date_active and least(nvl(a.end_date_active,sysdate-1),p_end_datel)
1230: AND a.start_date_active between p_start_datel and p_end_datel
1231: GROUP BY a.fund_id,

Line 1769: bim_intl_dates DA

1765: U.object_type object_type,
1766: AD.trdate transaction_create_date
1767: FROM (SELECT A.fund_id fund_id,TRUNC(DA.trdate) trdate
1768: FROM ozf_funds_all_b A,
1769: bim_intl_dates DA
1770: WHERE A.status_code IN ( 'ACTIVE','CANCELLED','CLOSED' )
1771: AND DA.trdate between A.start_date_active
1772: and least(nvl(A.end_date_active,sysdate-1),p_end_datel)
1773: AND A.start_date_active between p_start_datel and p_end_datel

Line 3145: bim_intl_dates b

3141: a.currency_code_fc currency_code_fc,
3142: a.original_budget original_budget,
3143: trunc(b.trdate) trdate
3144: FROM bim_r_fund_daily_facts a,
3145: bim_intl_dates b
3146: WHERE b.trdate between p_start_datel and p_end_datel+0.99999
3147: AND b.trdate between a.start_date and nvl(a.end_date,p_end_datel)+0.99999
3148: AND (a.fund_id, trunc(b.trdate)) not in (select c.fund_id, c.transaction_create_date
3149: from bim_r_fund_daily_facts c

Line 3271: bim_intl_dates b

3267: 0 transfer_in,
3268: 0 transfer_out,
3269: 0 holdback
3270: FROM ozf_funds_all_b ad,
3271: bim_intl_dates b
3272: WHERE ad.status_code in ('ACTIVE', 'CANCELLED', 'CLOSED')
3273: AND ad.start_date_active between p_start_datel and p_end_datel
3274: AND b.trdate between p_start_datel and p_end_datel+0.99999
3275: AND b.trdate between ad.start_date_active and nvl(ad.end_date_active,p_end_datel)+0.99999

Line 3899: bim_intl_dates b

3895: SELECT distinct a.fund_id fund_id,
3896: TRUNC(b.trdate) trdate
3897: FROM bim_r_fdsp_daily_facts a,
3898: ozf_funds_all_b f,
3899: bim_intl_dates b
3900: WHERE b.trdate between greatest(p_start_datel, f.start_date_active)
3901: and least(p_end_datel, nvl(f.end_date_active,p_end_datel))
3902: and f.fund_id = a.fund_id
3903: and (a.fund_id, TRUNC(b.trdate)) not in (select c.fund_id, c.transaction_create_date