DBA Data[Home] [Help]

APPS.OZF_FUND_UTILIZED_PUB dependencies on AMS_DELIVERABLES_ALL_TL

Line 72: ams_deliverables_all_tl tl,

68:
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