eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FUNDS_PUB dependencies on AMS_CATEGORIES_VL

Line 87: FROM ams_categories_vl

83: AND short_name = p_par_fund_name;
84:
85: CURSOR c_cat_exists (p_category_id IN NUMBER, p_category_name IN VARCHAR2) IS
86: SELECT 1
87: FROM ams_categories_vl
88: WHERE arc_category_created_for = 'FUND'
89: AND enabled_flag = 'Y'
90: AND category_name = p_category_name
91: AND category_id = p_category_id;

Line 95: FROM ams_categories_vl

91: AND category_id = p_category_id;
92:
93: CURSOR c_cat_id_exists (p_category_id IN NUMBER) IS
94: SELECT 1
95: FROM ams_categories_vl
96: WHERE arc_category_created_for = 'FUND'
97: AND enabled_flag = 'Y'
98: AND category_id = p_category_id;
99:

Line 102: FROM ams_categories_vl

98: AND category_id = p_category_id;
99:
100: CURSOR c_cat_name_exists (p_category_name IN VARCHAR2) IS
101: SELECT category_id
102: FROM ams_categories_vl
103: WHERE arc_category_created_for = 'FUND'
104: AND enabled_flag = 'Y'
105: AND category_name = p_category_name;
106: