APPS.BIM_POPDATES_PKG dependencies on OZF_ACT_BUDGETS

Line 22: ozf_act_budgets BU1

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')
26: AND bu1.approval_date <=trunc(o.start_date_active)

Line 34: ozf_act_budgets BU2

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)
38: AND bu2.status_code= 'APPROVED'

Line 44: FROM ozf_act_budgets a,

40: AND bu2.budget_source_type ='FUND'
41: AND bu2.budget_source_id = o.fund_id
42: union all
43: SELECT min(a.approval_date) de
44: FROM ozf_act_budgets a,
45: ams_campaigns_all_b b
46: WHERE a.budget_source_type ='FUND'
47: AND a.ARC_ACT_BUDGET_USED_BY = 'CAMP'
48: AND a.status_code ='APPROVED'

Line 54: FROM ozf_act_budgets a,

50: and b.actual_exec_start_date>p_date
51: and b.status_code in ('ACTIVE', 'CANCELLED', 'COMPLETED','CLOSED')
52: union all
53: SELECT min(a.approval_date)
54: FROM ozf_act_budgets a,
55: ams_event_headers_all_b b
56: WHERE a.budget_source_type ='FUND'
57: AND a.ARC_ACT_BUDGET_USED_BY = 'EVEH'
58: AND a.status_code ='APPROVED'