DBA Data[Home] [Help]

APPS.AMS_CPYUTILITY_PVT dependencies on AMS_OBJECT_ASSOCIATIONS

Line 538: FROM ams_object_associations

534: WHERE message_used_by_id = p_obj_id
535: AND message_used_by = p_obj_type;
536: CURSOR c_delv_exists(p_obj_id NUMBER, p_obj_type VARCHAR2) IS
537: SELECT COUNT(1)
538: FROM ams_object_associations
539: WHERE master_object_id = p_obj_id
540: AND master_object_type = p_obj_type ;
541: CURSOR c_prod_exists(p_obj_id NUMBER, p_obj_type VARCHAR2) IS
542: SELECT COUNT(1)