APPS.BIM_POPDATES_PKG dependencies on OZF_FUNDS_ALL_B

Line 21: FROM ozf_funds_all_b o,

17:
18: cursor min_object_date (p_date DATE) is
19: select trunc(min(de)) from (
20: select min(bu1.approval_date) de
21: FROM ozf_funds_all_b o,
22: ozf_act_budgets BU1
23: WHERE o.start_date_active > p_date
24: and o.status_code in ('ACTIVE','CANCELLED', 'CLOSED')
25: AND bu1.transfer_type in ('TRANSFER', 'REQUEST')

Line 33: FROM ozf_funds_all_b o,

29: AND bu1.act_budget_used_by_id = o.fund_id
30: AND bu1.budget_source_type ='FUND'
31: union all
32: select min(bu2.approval_date) de
33: FROM ozf_funds_all_b o,
34: ozf_act_budgets BU2
35: WHERE o.start_date_active > p_date --between p_start_datel and p_end_datel
36: AND o.status_code in ('ACTIVE','CANCEL', 'CLOSED')
37: AND bu2.approval_date <=trunc(o.start_date_active)