APPS.OZF_FUND_UTILIZED_PUB dependencies on JTF_LOC_HIERARCHIES_VL

Line 56: jtf_loc_hierarchies_vl loc,

52:
53: CURSOR c_valid_event (p_activity_id IN NUMBER, p_approver_id IN NUMBER) IS
54: SELECT event.event_header_id
55: FROM ams_event_headers_vl event,
56: jtf_loc_hierarchies_vl loc,
57: ams_act_access_denorm acc
58: WHERE loc.location_type_code = 'COUNTRY'
59: AND event.active_flag='Y'
60: AND event.event_level='MAIN'

Line 73: jtf_loc_hierarchies_vl c

69: CURSOR c_valid_deliverable (p_activity_id IN NUMBER) IS
70: SELECT b.deliverable_id
71: FROM ams_deliverables_all_b b,
72: ams_deliverables_all_tl tl,
73: jtf_loc_hierarchies_vl c
74: WHERE c.location_type_code = 'COUNTRY'
75: AND b.active_flag='Y'
76: AND c.location_hierarchy_id = b.country_id
77: AND b.deliverable_id = tl.deliverable_id