APPS.AMS_EVENTOFFER_PVT dependencies on AMS_CUSTOM_SETUP_ATTR

Line 344: SELECT count(*) FROM ams_custom_setup_attr

340: WHERE user_status_id = ust_id
341: AND system_status_type = 'AMS_EVENT_AGENDA_STATUS';
342:
343: CURSOR c_list_YN(id_in IN NUMBER) IS
344: SELECT count(*) FROM ams_custom_setup_attr
345: WHERE custom_setup_id = id_in
346: AND object_attribute = 'ILST'
347: AND ATTR_AVAILABLE_FLAG = 'Y';
348:

Line 6139: FROM ams_custom_setup_attr

6135: WHERE event_header_id = p_src_evh_id;
6136:
6137: CURSOR c_setup_resp(id_in IN NUMBER) IS
6138: SELECT 'x'
6139: FROM ams_custom_setup_attr
6140: WHERE custom_setup_id = nvl(id_in, 1006)
6141: and OBJECT_ATTRIBUTE = 'RESP';
6142: BEGIN
6143: SAVEPOINT copy_ev_header_to_offer;

Line 6378: FROM ams_custom_setup_attr

6374:
6375:
6376: CURSOR c_get_attr(l_setup_id IN NUMBER) IS
6377: SELECT object_attribute
6378: FROM ams_custom_setup_attr
6379: WHERE custom_setup_id = l_setup_id;
6380:
6381: TYPE t_obj_attr IS TABLE OF c_get_attr%ROWTYPE
6382: INDEX BY BINARY_INTEGER;