APPS.OZF_FUND_UTILIZED_PUB dependencies on AMS_DELIVERABLES_ALL_B

Line 81: FROM ams_deliverables_all_b b,

77: AND event.event_header_id = p_activity_id;
78:
79: CURSOR c_valid_deliverable (p_activity_id IN NUMBER) IS
80: SELECT b.deliverable_id
81: FROM ams_deliverables_all_b b,
82: ams_deliverables_all_tl tl,
83: jtf_loc_hierarchies_vl c
84: WHERE c.location_type_code = 'COUNTRY'
85: AND b.active_flag='Y'