1155: IF p_activity_association_id IS NOT NULL THEN
1156: BEGIN
1157: SELECT owning_department_id
1158: INTO l_owning_department_id
1159: FROM eam_org_maint_defaults
1160: WHERE object_id = p_activity_association_id AND object_type in (40, 60)
1161: AND organization_id = p_organization_id;
1162: EXCEPTION
1163: WHEN NO_DATA_FOUND THEN
1172: IF p_instance_id IS NOT NULL THEN
1173: BEGIN
1174: SELECT owning_department_id
1175: INTO l_owning_department_id
1176: FROM eam_org_maint_defaults
1177: WHERE object_id = p_instance_id AND object_type = 50
1178: AND organization_id = p_organization_id;
1179: EXCEPTION
1180: WHEN NO_DATA_FOUND THEN