APPS.OZF_FUNDS_PUB dependencies on AMS_MEDIA_VL

Line 131: FROM ams_media_vl

127: AND name = p_threshold_name;
128:
129: CURSOR c_task_exists (p_task_id IN NUMBER, p_task_name IN VARCHAR2) IS
130: SELECT 1
131: FROM ams_media_vl
132: WHERE media_type_code = 'DEAL'
133: AND media_name = p_task_name
134: AND media_id = p_task_id;
135:

Line 138: FROM ams_media_vl

134: AND media_id = p_task_id;
135:
136: CURSOR c_task_id_exists (p_task_id IN NUMBER) IS
137: SELECT 1
138: FROM ams_media_vl
139: WHERE media_type_code = 'DEAL'
140: AND media_id = p_task_id;
141:
142: CURSOR c_task_name_exists (p_task_name IN VARCHAR2) IS

Line 144: FROM ams_media_vl

140: AND media_id = p_task_id;
141:
142: CURSOR c_task_name_exists (p_task_name IN VARCHAR2) IS
143: SELECT media_id
144: FROM ams_media_vl
145: WHERE media_type_code = 'DEAL'
146: AND media_name = p_task_name;
147:
148: CURSOR c_bus_unit_exists (p_bus_id IN NUMBER, p_bus_name IN VARCHAR, p_org_id IN NUMBER) IS